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.
Topics:
"Performing Backup and Recovery" in Oracle Database 2 Day DBA
You can view objects in the Recycle Bin on the Dropped Objects page. 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.
To view objects in the Recycle Bin:
On the Workspace home page, click the SQL Workshop.
Click Utilities.
Click Recycle Bin.
Click Dropped Objects.
The Dropped Objects page appears.
See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.
To filter the report, select an object type, enter the object name in the Original Name field, and click Go.
To view object details, click the object name.
The Object Details page appears.
To restore the current object, click Restore Object.
To permanently delete the current object, click Purge Object.
To empty the Recycle Bin without viewing the objects:
On the Workspace home page, click SQL Workshop.
Click Utilities.
Click Recycle Bin.
Click Purge Recycle Bin.
The Purge Recycle Bin page appears.
Confirm your request by clicking Purge Recycle Bin again.