Flashback Recycle Bin Entry

From RapidSQL
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 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 Rapid SQL, expand the Recycle Bin node to display its contents.
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.


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


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

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