oracle 11g Flashback Data Archive(闪回数据归档)(三)
n 2353743;
COUNT(*)
----------
100
gyj@MYDB> select count(*) from test_gyj as of scn 2353790;
COUNT(*)
----------
0
gyj@MYDB> select count(*) from SYS_FBA_HIST_17908;
COUNT(*)
----------
0
gyj@MYDB>
select count(*) from SYS_FBA_HIST_17908;--刷新数据有缓慢,耐心等待!!!
COUNT(*)
----------
200
七、删除闪回归档数据
drop flashback archive flash1;