Oracle FAQ's

Recover a deleted rows from undo without flashback.

select * from testtable versions between timestamp to_timestamp('22-feb-2012 03:25:35' ,'dd-mon-rrrr HH24:MI:SS') and to_timestamp('22-feb-2012 03:28:35' ,'dd-mon-rrrr HH24:MI:SS')

This query will return the deleted rows of the test table in the mentioned time. This will work even without flashback on.

0 comments:

hits count
free counter
Oracle Headlines