Recover deleted data from a table in oracle with flashback

 If you deleted records in an oracle table that you didnot intend to, oracle flashback may be of assistnace.

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;