对于DML的FlashBack

SQL> select * from emp1;

         A

----------

        11

SQL> delete from emp1;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select * from emp1;

no rows selected

SQL> flashback table emp1 to scn 1535644;

ERROR at line 1:

ORA-08189: cannot flashback the table because row movement is not enabled

SQL> alter table emp1 enable row movement;  //允许rowid移动

Table altered.

SQL> flashback table emp1 to scn 1535644;

SQL> flashback table emp1 to scn 1535644;

Flashback complete.

SQL> select * from emp1;

         A

----------

        11

//OK，闪回Delte操作成功，对于其他DML操作也是一样。