Previous Next JavaScript must be enabled to correctly display this content

## 5.11 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 AI 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.

Parent topic: Using SQL Workshop Utilities

### 5.11.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.

Parent topic: Using the Recycle Bin

### 5.11.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.

Parent topic: Using the Recycle Bin