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.
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:
Post a Comment