Retrieving a Dropped Table

This section assumes that you created and then dropped the reg_hist table, as described in "Dropping a Table". The following procedure retrieves reg_hist from the recycle bin.

To perform the Flashback Drop operation:

1. On the Database Home page, click Availability to display the Availability subpage.

2. Click Perform Recovery in the Backup/Recovery section.

   The Perform Recovery page appears.

3. In the User-Directed Recovery section, select Tables from the Recovery Scope list.

   The page reloads with options appropriate for object-level recovery of tables.

4. Select Flashback Dropped Tables for the Operation Type, and then click Recover.

   The Perform Object Level Recovery: Dropped Objects Selection page appears.

5. Search among the dropped objects in the recycle bin for the objects to retrieve.

   For this example, enter hr in the Schema Name field and reg_hist in the Table field, and click Go.

   The Results section lists the objects matching your search. If needed, click the arrow next to Recycle Bin to expand its contents by one level, showing dropped tables matching your search but not their dependent objects.

6. Select each table to retrieve using Flashback Drop.

   For this example, select reg_hist and then click Next.

   Note: When a table is retrieved from the recycle bin, all the dependent objects for the table that are in the recycle bin are retrieved with it. They cannot be retrieved separately.

   The Perform Object Level Recovery: Rename page appears.

7. If needed, enter new names for dropped objects that you are retrieving. For this scenario, do not specify a new name. Click Next.

   The primary reason for renaming objects when you retrieve them from the recycle bin is because you might have created new tables with the same names as tables being retrieved. If you must rename some objects, then enter new names as needed in the New Name field.

   The Perform Object Level Recovery: Review page appears. This page displays an impact analysis, showing the full set of objects to be flashed back, including the dependent objects, and the names they will have when the Flashback Drop operation is complete.

8. Review the changes and then click Submit.

   A confirmation page should indicate the success of the operation.

9. Click OK to return to the Availability page.