SQL> var scn number
SQL> exec :scn := dbms_flashback.get_system_change_number
PL/SQL 過程已成功完成。
SQL> select count(*) from t;
COUNT(*)
----------
26
SQL> delete from t;
已刪除26行。
SQL> commit;
提交完成。
SQL> select count(*) from t as of scn :scn;
COUNT(*)
----------
26
SQL> select * from (select count(*) from t), (select count(*) from t as of scn :
scn);
COUNT(*) COUNT(*)
---------- ----------
0 26
SQL> flashback table t to scn :scn;
flashback table t to scn :scn
*
第 1 行出現(xiàn)錯(cuò)誤:
ORA-08189: 因?yàn)槲磫⒂眯幸苿?dòng)功能, 不能閃回表
SQL> select * from (select count(*) from t), (select count(*) from t as of scn :
2 scn);
COUNT(*) COUNT(*)
---------- ----------
26 26
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
會(huì)話已更改。
SQL> flashback table t to timestamp to_timestamp('2007-03-30:15:24:19','yyyy-m
m-dd:hh24:mi:ss');
Prerequisites for Using Flashback Table
The prerequisites for performing a FLASHBACK TABLE operation are as follows:
|
