Oracle9i中FlashBack闪回查询操作实例(scn)

C:\Documents and Settings\acer>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 8月 21 17:23:35 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>  connect testuser/testuser
已连接。
SQL> select * from testtable2;

    DEPTNO DNAME                        LOC
---------- ---------------------------- --------------------------
        11 abc                          123
        45 sales                        chicago
        46 research                     dallas
        47 bbb                          777
         1 research                     dallas

SQL> select dbms_flashback.get_system_change_number fscn from dual;

      FSCN
----------
 316227956

SQL>  update testtable2 set deptno = '55' where dname = 'abc';

已更新 1 行。

SQL> commit;

提交完成。

SQL> select * from testtable2;

    DEPTNO DNAME                        LOC
---------- ---------------------------- --------------------------
        55 abc                          123
        45 sales                        chicago
        46 research                     dallas
        47 bbb                          777
         1 research                     dallas

SQL> select * from TESTTABLE2 AS OF SCN('316227956');

    DEPTNO DNAME                        LOC
---------- ---------------------------- --------------------------
        11 abc                          123
        45 sales                        chicago
        46 research                     dallas
        47 bbb                          777
         1 research                     dallas

SQL> INSERT INTO TESTTABLE2 SELECT * FROM TESTTABLE2 AS OF SCN('316227956') WHER
E DEPTNO='11';

已创建 1 行。

SQL>  select * from testtable2;

    DEPTNO DNAME                        LOC
---------- ---------------------------- --------------------------
        55 abc                          123
        45 sales                        chicago
        46 research                     dallas
        47 bbb                          777
         1 research                     dallas
        11 abc                          123

已选择6行。

SQL> DELETE FROM  testtable2 WHERE DEPTNO ='11';

已删除 1 行。

SQL> COMMIT;

提交完成。

SQL>  select * from testtable2;

    DEPTNO DNAME                        LOC
---------- ---------------------------- --------------------------
        55 abc                          123
        45 sales                        chicago
        46 research                     dallas
        47 bbb                          777
         1 research                     dallas

SQL语法4：【上一篇】
9i for windows 启动到自动归档模式：【下一篇】