Performing a Flashback Table Operation

In this example, you rewind the hr.employees table and its dependent tables to a previous point in time.

To perform the Flashback Table operation:

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

2. Select Perform Recovery from the Manage 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. For Operation Type, choose Flashback Existing Tables, and click Recover.

   The Perform Object Level Recovery: Point-in-time page appears.

5. Choose the target time for the Flashback Table operation, and click Next.

   Note: If you do not know the time at which the unwanted changes occurred, then you can investigate the history of transactions affecting this table by selecting Evaluate row changes and transactions to decide upon a point in time. Oracle Flashback Version Query enables you to review all recent changes to the target table. Use of this feature is beyond the scope of this documentation.

   For this example, assume that rows were accidentally inserted 5 minutes ago. Select Flashback to a timestamp and enter a time 5 minutes before now.

   The Perform Object Level Recovery: Flashback Tables page appears.

6. Enter table names in the Tables to Flashback text box and then click Next.

   You can enter multiple table names to flash back several tables to the same time. You can also click Add Tables and search for more tables. For this example, enter the text hr.employees in the Tables to Flashback text box.

   If your table has other dependent tables, then the Dependency Options page appears. This page asks how dependencies should be handled.

7. Do one of the following, and then click Next:

   • Select Cascade to flash back any dependent tables.

   • Select Restrict to flash back only the target table.

   • Select Customize to choose which dependent tables to flash back and which to leave as they are.

   You can click Show Dependencies to see which tables will be affected.

   Note: Row movement must be enabled on all affected tables, not just the initial target tables.

   In this example, the hr.employees table has dependent tables hr.jobs and hr.departments, so select Cascade and then click Next.

   The Perform Object Level Recovery: Review page appears.

8. Click Submit.

   When the operation is completed, a Confirmation page displays the results. Click OK.