| December 12, 2007 01:51:49 |
#1 |
| sp_sarang |
Member Since: December 2007 Total Comments: 1 |
RE: Whats the Concept of Flashback Query?
|
It lets you to view and repair historical data.They query the database by TIME or user specified SCN. It do not UNDO anything .It is only a query mechanism.You can take o/p from flashback query and perform an undo yourself.
It do not work through DDL operation.
for example, the data before 5 minutes which has lost is repaired as-
execute dbms_flashback.enable_at_time(sysdate-5/1440);
............................................
execute dbms_flashback.disable |
| |
