James's Blog

Oracle: 9i flashback query

Flashback Query is enabled and disabled using the DBMS_FLASHBACK package. The point in time of the flashback can be specified using the SCN or the actual time:

EXECUTE Dbms_Flashback.Enable_At_System_Change_Number(123);
EXECUTE Dbms_Flashback.Enable_At_Time('28-AUG-01 11:00:00');

Once you've finished performing all your read-only operations you can turn off flashback query using:

EXECUTE Dbms_Flashback.Disable;

to get current system change number

select dbms_flashback.get_system_change_number from dual;

posted by James Pei @ 1:58 PM