Important Points - Flashback Table

• You can’t flashback the table to an SCN prior to SCN XXXX ,when a specific type of DDL occurred at XXXX. These DDL operations are as follows,
  
  1. Adding constraint to a table
  2. Dropping a column
  3. Modifying a column
  4. Truncating a table
  5. Moving table to a different Tablespace
  6. Adding, dropping, merging, splitting, coalescing, truncating a partition or subpartition. Adding a range partition is acceptable.
  7. Adding table to a cluster.
  
• When you flash back the table to a SCN prior to XXXX(when the index dropped), the index is not reinstated. Dropped objects are not recreated.
• When you flash back a table, the statistics on the table are not reinstated. When you flashback the table to SCN 1500 the statistics on the table are as of current SCN.

Thanks