SQL> create table test(id number(3)); SQL> insert into test values (1); SQL> insert into test values(2); SQL> commit; SQL> create table rec_date(date_scn);
注意:在执行步骤3或者步骤4之前,等待5分钟。
(3)删除记录
SQL> execute dbms_flashback.disable; SQL> insert into rec_date select sysdate from dual; SQL> commit; SQL> delete from test where id=1; SQL> commit;