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:

Connect Oracle Recovery Manager (RMAN) to the target database as described in "Connecting to the Target Database Using RMAN."
Enable row movement for all the objects that you want to rewind using Flashback Table.
The following command enables row movement for the hr.employees table.
```
ALTER TABLE hr.employees ENABLE ROW MOVEMENT;
```
For this example, you must also enable row movement on the tables hr.jobs and hr.departments.