闪回查询用例

来源：互联网发布：云南大学软件学院排名编辑：程序博客网时间：2024/05/29 11:32

SQL> conn hr/hrConnected.SQL> select * from tab;TNAME       TABTYPECLUSTERID------------------------------ ------- ----------REGIONS        TABLECOUNTRIES       TABLELOCATIONS       TABLEDEPARTMENTS       TABLEJOBS       TABLEEMPLOYEES       TABLEJOB_HISTORY       TABLEEMP_DETAILS_VIEW       VIEW8 rows selected.SQL> create table t1 as select * from EMPLOYEES;Table created.SQL> insert into t1 select * from t1;107 rows created.SQL> commit;Commit complete.SQL> select current_scn from v$database;CURRENT_SCN-----------     252184SQL> delete t1;214 rows deleted.SQL> commit;Commit complete.SQL> select current_scn from v$database;CURRENT_SCN-----------     252196SQL> select count(*) from t1;  COUNT(*)---------- 0SQL> select count(*) from t1 as of scn 252184;  COUNT(*)----------       214

--多试几个数，可以用来定位具体的删除点...SQL> select count(*) from t1 as of scn 252192;  COUNT(*)----------       214SQL> select count(*) from t1 as of scn 252193;  COUNT(*)---------- 0

0 0