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