ITPub博客

该特性是ORACLE 9开始引入的，9I开始使用了AUM，通过关键字as of可以对表、视图、物化视图进行flashback query。常用timestamp或scn进行操作。使用案例：假设有表t1被开发人员做了记录误删除1、确认数据库scn变化select name,first_change# fscn,next_change# nscn,first_time from v$archived_log;2、确认当前scnselect dbms_flashback.get_system_change_number from dual;3、创建恢复表create table t1_reco as select * from t1 where 1=0;4、恢复select count(*) from t1 as of scn *****或者select count(*) from t1 as of timestam