Recover deleted data from a table in oracle with flashback

 

If you deleted records in an oracle table that you did not intend to, oracle flashback may be of assistance.

You might need to alter the table to enable row movement.

 

alter table <table_name> enable row movement;


The below query checks to see what the records looked like an hour ago.

 

select * from  <table_name> as of timestamp systimestamp - interval '1' hour;

To restore the record, you execute the flashback command.

 

flashback table <table_name> to timestamp systimestamp - interval '1' hour;