oracle 11g Flashback Data Archive(闪回数据归档)(三)

2014-11-24 12:32:59 · 作者: · 浏览: 2
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;