To perform the Flashback Table operation

To perform the Flashback Table operation:
1. Connect RMAN to the target database as described in "Connecting to the Target
Database" on page 9-9.
2. Determine whether the table that you intend to flash back has dependencies on
other tables.
Use the following SQL query to determine the dependencies for the hr.employees:
SELECT other.owner, other.table_name
FROM sys.all_constraints this, sys.all_constraints other
WHERE this.owner = 'HR'
AND this.table_name = 'EMPLOYEES'
AND this.r_owner = other.owner
AND this.r_constraint_name = other.constraint_name
AND this.constraint_type='R';
OWNER TABLE_NAME
------------------------------ ------------------------------
HR EMPLOYEES
HR JOBS
HR DEPARTMENTS
3. Ensure that row movement is enabled for the table that you want to flash back and
its dependent tables.
In this example, row movement must be enabled for the tables hr.employees,
hr.jobs, and hr.departments using the steps described in "Enabling Row
Movement on a Table" on page 9-34.
4. Identify the time, SCN, or restore point to which you want to return the table.
In this example, we assume that the rows were accidentally inserted 5 minutes
ago. Therefore, you must rollback to a timestamp that is 5 minutes before the
current time.
... zobacz całą notatkę