----审计查询对表进行的操作
SQL>select empno,ename,sal,versions_operation,versions_xid,versions_starttime
from scott.emp2 versions
between timestamp minvalue and maxvalue
order by empno,versions_starttime;
---通过上一条查询得出的xid找出删除的数据,然后进行恢复(须以sysdba登录)
SQL>select logon_user,table_name,table_owner,undo_sql
from FLASHBACK_TRANSACTION_QUERY
where table_owNer='SCOTT' AND XID='07002F0087080000';
---查询某个时间的表数据行数
SQL>select * from scott.emp2 AS of TIMESTAMP to_timestamp('2013-07-19 10:30:00','yyyy-mm-dd hh24:mi:ss');
---闪回被删除的表数据
SQL> Flashback table emp2 to timestamp to_timestamp('2013-07-19 10:20:00','yyyy-mm-dd hh24:mi:ss');
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23604335/viewspace-772114/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23604335/viewspace-772114/