Difference between revisions of "Flashback"
From dbawiki
(Created page with "===Enable flashback=== exec dbms_flashback.enable; ===Disable flashback=== exec dbms_flashback.disable; ===To put the session back in time=== Note: undo_management must be auto...") |
(No difference)
|
Revision as of 00:05, 11 November 2012
Enable flashback
exec dbms_flashback.enable;
Disable flashback
exec dbms_flashback.disable;
To put the session back in time
Note: undo_management must be auto Note: Take a look at undo_retention to get an idea of how far back you might be able to go.
exec dbms_flashback.enable_at_time(to_date('2012-AUG-24 12:00:00', 'YYYY-MON-DD HH24:MI:SS'));
