5.10 Using the Recycle Bin

You can use the Recycle Bin to view and restore dropped database objects.

Required: You must enable Flashback Drop in the database to use the Recycle Bin in SQL Workshop.

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.

• 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.

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:

1. On the Workspace home page, click the SQL Workshop.
2. Click Utilities.
3. Click Recycle Bin.
4. Click Dropped Objects.

   The Dropped Objects page appears.

5. To filter the report, select an object type, enter the object name in the Original Name field, and click Go.
6. To view object details, click the object name.

   The Object Details page appears.

7. To restore the current object, click Restore Object.
8. To permanently delete the current object, click Purge Object.

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:

1. On the Workspace home page, click SQL Workshop.
2. Click Utilities.
3. Click Recycle Bin.
4. Click Purge Recycle Bin.

   The Purge Recycle Bin page appears.

5. Confirm your request by clicking Purge Recycle Bin again.