Whats the Concept of Flashback Query?

Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?

cosmoct
Profile Answers by cosmoct Questions by cosmoct
Dec 16th, 2007
3
3359

Showing Answers 1 - 3 of 3 Answers

sp_sarang
Profile Answers by sp_sarang

Dec 21st, 2007

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