Flashback Query.
Query values in a table at a point in time.
select * from rays.VIMPORTANTDATA
as of timestamp to_timestamp('25-FEB-2010 08:10:00',
'DD-MON-YYYY HH24:MI:SS');
or
select * from rays.VIMPORTANTDATA
as of timestamp to_timestamp('25-FEB-2010 08:10:00',
'DD-MON-YYYY HH24:MI:SS');
where employee_name = 'Smith';
It can also be used with an insert data to restore data
Insert into rays.VIMPORTANTDATA (
select * from rays.VIMPORTANTDATA
as of timestamp to_timestamp('25-FEB-2010 08:10:00',
'DD-MON-YYYY HH24:MI:SS');
where employee_name = 'Smith');
WARNINGS
1) Does not work for truncated data (not in undo),
2) Subject to UNDO retention rules.
3) LONG columns cannot be selected in this way
