79921

Recovering a Dropped Table Using Oracle Flashback Drop

Oracle Flashback Drop cnablcs you to rcversc the effects of dropping (deleting) a table,

returning the dropped table to the database along with dependent objects such as indexes and triggers. This feature Stores dropped objects in a recycle bin, from which they can be retrieved until the recycle bin is purged, either explicitly or because space is needed.

As with Flashback Table, you can use Flashback Drop while the database is open. Also, you can perform the flashback without undoing changes in objects not affected by the Flashback Drop operation. Flashback Table is morę convenient than forms of media recovery that require taking the database offline and restoring files from backup.

This section eon tai ns the fol łowi ng topics:

■Dropping a Table ■Retrieving a Dropped Table