Is it possible to do flashback after truncate? Is there any possibility of doing flashback after truncate ? Thank you in advance.
Sadly no. At least not by default and not directly. For this you need to read about Flashback Data Archives . By default they are disabled for all tables, but it can be activated, and will preserve your data even after a truncate. Moreover, even if you have the FDAs, you cannot just flashback the table, because TRUNCATE is a DDL operation, and will throw you an error that the table definition has been changed.

What you can do though, is to select the data to a point from the flashback table, and insert it back in yours:

insert into table1
select * from table1 as of timestamp to_timestamp(&lt;your_time&gt;)


Note! This can be done only after you have flashback data archives for that table.

Hope this helped!