Oracle9i Flashback Query 闪回查询总结 --- (通过SCN恢复)

  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