Sunday, March 30, 2014

Oracle Tip: Recover Deleted Rows from a Table

Problem : Recover deleted rows from a table

Solution : Using timestamp you can recover the deleted data form a table. You can select the data and store it in another table for finding the missing data.

Select * from table1 as of timestamp(to_timestamp('2014-03-29 11:00:00','yyyy-mm-dd hh:mi:ss'))