6.1. An Overview of Flashback Technologies

Flashback Technologies consist of the Flashback Drop, Flashback Versions Query, Flashback Transaction Query, Flashback Table, and the supporting Recycle Bin. The Flashback Query, first made available in Oracle 9i, and the rest of the Flashback Technologies that are new to Oracle 10g all rely on the undo data to rebuild dropped objects. Undo data are the records of the changes of each update to an Oracle database and the values that were overwritten by those updates. In addition, the Flashback Technologies are enabled by default.

All of the Flashback Technologies are designed to recover from user error or logical corruption:

  • The Flashback Table is designed to recover a table in situations such as when ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.