Understanding Flashback Technology - OCP: Oracle Database 12c Administrator Certified Professional - page 382

exeRCiSe 8.3
Using Flashback Table
To practice using the Flashback Table feature, continue using the table created in
Exercise 8.2, and perform the following:
1. Select all rows from the table.
SQL> alter table foo enable row movement;
Table altered.
SQL> select * from foo;
X Y
---------- ----------
1 test1
2 test2
3 test3
4 test4
5 test5
2. Verify the system time at which the last two rows were inserted as part of the previ-
ous exercise.
3. Flash back the table to the system time verified in step 2:
SQL> flashback table foo to timestamp to_timestamp (
'18-AUG-13 22:24:11','DD-MON-YY HH24:MI:SS');
Flashback complete.
SQL> select * from foo;
X Y
---------- ----------
1 test1
2 test2
3 test3