Query Flashbacks : Flashbacks « Transaction « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Transaction
  3. Flashbacks

If you mistakenly commit changes and you want to view rows as they originally were, you can use a query flashback.

You can then use the results of a query flashback to manually change rows back to their original values if you need to.

In addition, flashbacks can be based on a datetime or system change number (SCN).

The database uses SCNs to track changes made to data, and you can use them to flash back to a particular SCN in the database.









35.6.Flashbacks
35.6.1.Query Flashbacks
35.6.2.Granting the Privilege for Using Flashbacks
35.6.3.Time Query Flashbacks
35.6.4.To disable a flashback, you execute DBMS_FLASHBACK.DISABLE()
35.6.5.System Change Number Query Flashbacks
35.6.6.DBMS_FLASHBACK.ENABLE_AT_SYSTEM_CHANGE_NUMBER() procedure enables you to perform a flashback to an SCN.