Database Reference
In-Depth Information
To take the table to prior point in time, use the following SQL
statement. Make sure you enable row movement at the table
level first.
SQL> ALTER TABLE emp ENABLE ROW MOVEMENT;
SQL> FLASHBACK TABLE emp TO TIMESTAMP
TO_TIMESTAMP('2007-09-10 05:20:44 PM', 'YYYY-MM-
DD HH:MI:SS AM');
OR
SQL> FLASHBACK TABLE emp TO TIMESTAMP
SYSTIMESTAMP - INTERVAL '10' MINUTES;
This statement takes the table 'emp' prior to 10 minutes to the
execution of the statement. The SYSTIMESTAMP gives the
current system data/time. The syntax for time based flashback is
as follows. You can use more than one table in place of
<table_name> separated by comma (,). Each of the tables must
have row movement enabled first.
SQL> FLASHBACK TABLE <table_name> TO TIMESTAMP
<timestamp>;
Using SCN we use the following statement. Make sure you
enable row movement on the table before executing flashback
based on SCN.
SQL> FLASHBACK TABLE emp TO SCN 183434;
You can get the SCN information from the V$DATABASE
dynamic performance view.
SQL> SELECT current_scn
FROM v$database;
Search WWH ::




Custom Search