Enabling Row Movement on a Table

Before you can use Flashback Table, you must ensure that row movement is enabled on the table to be flashed back, or returned to a previous state. Row movement indicates that rowids will change after the flashback occurs. This restriction exists because if rowids before the flashback were stored by an application, then there is no guarantee that the rowids will correspond to the same rows after the flashback.

To enable row movement on a table:

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

2. Click Tables in the Database Objects section.

   The Tables page appears.

3. To find the target table for Flashback Table, do the following:

   1. Enter the schema name in the Schema field and, optionally, the table name in the Object Name field.

   2. Click Go to search for the table.

      When you search for tables, for example, in the hr schema, you may have to page through the search results to find your table.

4. Select the table from the list of tables and click Edit.

   In this scenario, select employees.

   The Edit Table: table_name page appears.

5. Click Options to go to the Options subpage.

6. Complete the following steps:

   1. Set Enable Row Movement to Yes.

   2. Click Apply to update the options for the table.

   An update message appears.

7. Complete the following steps:

   1. Click Tables at the top of the page to return to the search results.

   2. Enable row movement on more tables by repeating Step 1 through Step 6 for each table.

   For this example, you should also enable row movement on the tables hr.jobs and hr.departments.