5.10 Using the Recycle Bin
You can use the Recycle Bin to view and restore dropped database objects.
When you drop a table, the space associated with the table is not immediately removed. The Oracle database renames the table and places it and any associated objects in the Recycle Bin. You can recover objects in the Recycle Bin at a later time.
Note:
The Recycle Bin feature is only available if you run with an Oracle 10g or later database.
- Managing Objects in the Recycle Bin
Once you select an object and view the Object Details page, you can choose to purge the object or restore the object by clicking the appropriate button. - Emptying the Recycle Bin Without Viewing the Objects
You can empty the Recycle Bin without viewing the objects by using Purge Recycle Bin option.
Parent topic: Using SQL Workshop Utilities
5.10.1 Managing Objects in the Recycle Bin
Once you select an object and view the Object Details page, you can choose to purge the object or restore the object by clicking the appropriate button.
You can view objects in the Recycle Bin on the Dropped Objects page.
To view objects in the Recycle Bin:
Parent topic: Using the Recycle Bin
5.10.2 Emptying the Recycle Bin Without Viewing the Objects
You can empty the Recycle Bin without viewing the objects by using Purge Recycle Bin option.
To empty the Recycle Bin without viewing the objects:
Parent topic: Using the Recycle Bin