闪回查询用例

SQL> conn hr/hr
Connected.
SQL> select * from tab;

TNAME			       TABTYPE	CLUSTERID
------------------------------ ------- ----------
REGIONS 		       TABLE
COUNTRIES		       TABLE
LOCATIONS		       TABLE
DEPARTMENTS		       TABLE
JOBS			       TABLE
EMPLOYEES		       TABLE
JOB_HISTORY		       TABLE
EMP_DETAILS_VIEW	       VIEW

8 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
-----------
     252184

SQL> delete t1;

214 rows deleted.

SQL> commit;

Commit complete.

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
     252196

SQL> select count(*) from t1;

  COUNT(*)
----------
	 0

SQL> select count(*) from t1 as of scn 252184;

  COUNT(*)
----------
       214

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

  COUNT(*)
----------
       214

SQL> select count(*) from t1 as of scn 252193;

  COUNT(*)
----------
	 0