Flashback Recycle Bin Entry
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
- ORCL 10g^
To Recover a Table Currently in the Recycle Bin
- 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
- Recycle Bin (for a support summary including topics such as displaying Recycle Bin contents)
- Enable Recycle Bin
- Purge Recycle Bin Entry
- Purge Recycle Bin