Enabling Row Movement on a Table - wykład

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. Connect RMAN to the target database as described in "Connecting to the Target
Database" on page 9-9.
2. 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.
Performing User-Directed Recovery
Performing Backup and Recovery 9-35
ALTER TABLE hr.employees ENABLE ROW MOVEMENT;
For this example, you must also enable row movement on the tables hr.jobs and
hr.departments.
... zobacz całą notatkę