Using the Recycle Bin to View and Restore Dropped Objects

If you are running Oracle HTML DB with Oracle Database 10g release 1 (10.1) or later, 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 where it can be recovered at a later time.

Topics:

Managing Objects in the Recycle Bin
Emptying the Recycle Bin

Note:

The Recycle Bin feature is only available if you are running Oracle HTML DB with an Oracle 10g or later database.

Managing Objects in the Recycle Bin

To view objects in the Recycle Bin:

Click the SQL Workshop icon on the Workspace home page.
Click Utilities.
Click Recycle Bin.
Click View Objects.
To filter the report, select an object type, enter the object name in the Original Name field, and click Go.
Click the View icon to access the Object Detail page. On this page you can:
To view object details, click the View icon adjacent to the original name.

On the Object Details page, you can:
- Click Restore Object to restore the current object
- Click Purge to permanently delete the current object

Emptying the Recycle Bin

To empty the Recycle Bin without viewing the objects:

Click the SQL Workshop icon on the Workspace home page.
Click Utilities.
Click Recycle Bin.
From the Tasks list on the right side of the page, select Purge Recycle Bin.