"Practice" flash back Table

1. Delete Table dept1:

 -: the: -SCOTT@ORA11GR2>Select *  fromdept1; DEPTNO dname LOC---------- -------------- -------------         -DALLAS -SALES CHICAGO +OPERATIONS BOSTON -xxx xxxx -: the: -SCOTT@ORA11GR2>Delete  fromdept1;4rows deleted. -: A:WuyiSCOTT@ORA11GR2>Commit;CommitComplete.

2. Allow row movement (use flashback table must first allow row movement)

: SCOTT@ORA11GR2>alter table  dept1 Enable row movement; Table altered.

3. Flash Back table:

 -: -: +SCOTT@ORA11GR2>FlashbackTableDept1 to timestampTo_timestamp ('2016-11-11 13:09:47','YYYY-MM-DD Hh24:mi:ss'); Flashback complete. -: the: -SCOTT@ORA11GR2>Select *  fromdept1; DEPTNO dname LOC---------- -------------- -------------         -DALLAS -SALES CHICAGO +OPERATIONS BOSTON -xxx xxxx

"Practice" flash back Table