6.2. Using Flashback Drop

Flashback Drop is the process of saving a copy of the dropped database object and dependent objects in the Recycle Bin so that these objects can be recovered if necessary. The dropped database object is not removed from the database until the Recycle Bin is emptied. This provides a mechanism for a user to recover an accidental drop of a table. In previous releases of Oracle, you most likely needed to perform an incomplete recovery, import, or use Log Miner to recover dropped database objects. Flashback Drop is substantially faster than most other recovery mechanisms previously available. In addition, a Flashback Drop does not impact other users in the database to restore a dropped table, whereas incomplete recovery ...

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.