Example: Restoring a Table from the Recycle Bin

Previous

Next

---

Suppose you drop the JOB_HISTORY table in the HR schema, and then decide that you want to recover it. You can recover (undrop) the table by restoring it from the recycle bin.

To drop the JOB_HISTORY table and then restore it from the recycle bin:

1. Access the Database Home Page, and log in to the database as user HR.

   See "Accessing the Database Home Page" for instructions.

   
   

   Note: You must have previously unlocked the HR account and assigned it a password. See "Altering Users" and "Locking and Unlocking User Accounts" for more information.

   
   

2. Click the Object Browser icon.

   The Object Browser page appears, showing the tables in the HR schema.

3. Click the JOB_HISTORY table.

   Details on this table appear in the right side of the page.

   
   Description of the illustration job_history.gif
   
   

4. Click the Drop button (underneath the Triggers link).

   A Drop Object Confirmation window appears.

5. Click Finish to drop the table.

   The table is removed from the list of tables at the left-hand side of the page.

6. Click Home in the breadcrumb trail at the top of the page to return to the Database Home Page.

7. Click the Utilities icon, and then click the Recycle Bin icon.

8. Click the Dropped Objects icon.

   The Dropped Objects page appears, displaying the JOB_HISTORY table and its indexes in a list.

   
   Description of the illustration dropped_objects.gif
   
   

9. Under the Original Name column, click the table name JOB_HISTORY.

   The Object Details page appears, displaying information on the JOB_HISTORY table.

   
   Description of the illustration dropped_object_details.gif
   
   

10. Click Restore Object.

    A confirmation page appears. The table and all of its dependent objects are restored.