m user_tables where table_name='T1';
www.2cto.com
ROW_MOVEMENT
----------------
ENABLED
16:21:09 hr@ORCL (^ω^) select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
4199918
16:22:52 hr@ORCL (^ω^) select count(*) from t1;
COUNT(*)
----------
8
16:23:22 hr@ORCL (^ω^) delete t1 where rownum=1;
已删除 1 行。
16:23:31 hr@ORCL (^ω^) commit;
提交完成。
16:23:36 hr@ORCL (^ω^) flashback table t1 to scn 4199918;
闪回完成。 www.2cto.com
16:24:19 hr@ORCL (^ω^) select count(*) from t1;
COUNT(*)
----------
8