闪回查询用例

最新推荐文章于 2021-06-08 14:47:36 发布

aio_o

最新推荐文章于 2021-06-08 14:47:36 发布

阅读量959

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle10g 文章标签： Oracle database select 闪回闪回查询

本文链接：https://blog.youkuaiyun.com/mvccc/article/details/37764155

oracle10g 专栏收录该内容

13 篇文章

订阅专栏

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