oracle 10g flash 闪回

1. create table t_flash(id number(5),name varchar2(20));

 

2. begin

      for i in 1..1000

      loop

         insert into t_flash(id,name) values(i,i);

      end loop;

     end;

3. commit;

 

4. select dbms_flashback.get_system_change_number() from dual;

 

5. 得到scn 884349907705

 

6. delete from t_flash;

 

7. select count(*) from t_flash;

 

8. select count(*) from t_flash as of scn 884349907705;

 

9. insert into t_flash select id,name from t_flash as of scn 884349907705

 

10. select scn_to_timestamp(dbms_flashback.get_system_change_number()) from dual;(可以根据scn )