oralce 闪回

最新推荐文章于 2024-03-30 21:31:09 发布

iteye_7135

最新推荐文章于 2024-03-30 21:31:09 发布

阅读量72

点赞数

分类专栏： oralce 学习文章标签： SQL

本文链接：https://blog.csdn.net/iteye_7135/article/details/81963240

版权

oralce 学习专栏收录该内容

2 篇文章 0 订阅

订阅专栏



sys@ORCL> variable scn number;
sys@ORCL> exec :scn :=dbms_flashback.get_system_change_number;

PL/SQL procedure successfully completed.

sys@ORCL> print scn;

       SCN
----------
    697882

sys@ORCL> select count(*) from big_table;

  COUNT(*)
----------
     10005

sys@ORCL> delete from big_table;  --删除数据

10005 rows deleted.

sys@ORCL> select count(*) from big_table; --检测是否删除

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


sys@ORCL> select count(*) from big_table as of scn:scn;

  COUNT(*)
----------
     10005

sys@ORCL> commit; --跨事务

Commit complete.

sys@ORCL> select * 
  2  from (select count(*) from big_table),(select count(*) from big_table as of scn:scn) 
  3  /

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

sys@ORCL> flashback table big_table to scn:scn;
flashback table big_table to scn:scn
                *
ERROR at line 1:
ORA-08185: Flashback not supported for user SYS


sys@ORCL> show user;
USER is "SYS"