Flashback Recycle Bin Entry

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you build and submit a FLASHBACK TABLE... TO BEFORE DROP statement against a table in the Recycle Bin. This recovers the table and restores it to its state immediately before the drop.

Note: The Datasource Navigator/Explorer entry for a Recycle Bin entry has a Can Undrop field that indicates whether a Flashback Recycle Bin Entry action can be performed against the item

Platform Availability

To Recover a Table Currently in the Recycle Bin

1. In the DBArtisan Datasource Navigator/Explorer, under an Oracle Schema node, select the Recycle Bin node. Contents of the Recycle Bin are displayed.
2. Right-click one or more selected tables in the Recycle Bin and select Flashback Recycle Bin Entry from the context menu. The Flashback Recycle Bin Entry dialog opens.
3. Use the following table as a guide to understanding and modifying settings in the wizard:
Step Settings and tasks

Action options

Displays the table entries you selected to restore.

Dependencies

Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies.

Preview

Preview the DDL generated for the operation. For more information, see Preview.

4. Click Execute. For information on the scheduling option, see Scheduling.

Topics