SQL> conn test/test;
Connected.
SQL> select * from mytest2;
NAME EMAIL
-------------------- ------------------------------
mingming lsm_3036@163.com
weiwei liangliang@163.com
SQL> alter table mytest2 enable row movement;
Table altered.
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
1404479
SQL> insert into mytest2 values('xinxin','xinxin@163.com');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from mytest2;
NAME EMAIL
-------------------- ------------------------------
mingming lsm_3036@163.com
weiwei liangliang@163.com
xinxin xinxin@163.com
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
1404525
SQL> delete from mytest2;
3 rows deleted.
SQL> commit;
Commit complete.
SQL> flashback table mytest2 to scn 1404479;
Flashback complete.
SQL> select * from mytest2;
NAME EMAIL
-------------------- ------------------------------
mingming lsm_3036@163.com
weiwei liangliang@163.com
SQL> delete from mytest2;
2 rows deleted.
SQL> commit;
Commit complete.
SQL> flashback table mytest2 to scn 1404525;
Flashback complete.
SQL> select * from mytest2;
NAME EMAIL
-------------------- ------------------------------
mingming lsm_3036@163.com
weiwei liangliang@163.com
xinxin xinxin@163.com
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31448824/viewspace-2137529/ ，如需转载，请注明出处，否则将追究法律责任。
