Flashback Transaction Query
Flashback Transaction Query也是使用UNDO信息来实现。利用这个功能可以查看某个事务执行的所有变化,它需要访问
flashback_transaction_query 视图,这个视图的XID列代表事务ID,利用这个ID可以区分特定事务发生的所有数据变化。
*******************************个人操作****************************
insert into scott.emp values(7970,'lu','CLERK',7902,to_date('2011-09-09','YYYY-mm-dd'),'800','300',20);
commit;
SQL> Select xid,operation,commit_scn,undo_sql
2 from flashback_transaction_query
3 where xid in (Select versions_xid from scott.emp versions between scn minva
lue and maxvalue);
XID OPERATION COMMIT_SCN
---------------- -------------------------------- ----------
UNDO_SQL
--------------------------------------------------------------------------------
06001E00A8040000 INSERT 3479779
delete from "SCOTT"."EMP" where ROWID = 'AAANMlAAEAAAAG8AAA';
06001E00A8040000 BEGIN 3479779
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26446098/viewspace-712223/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26446098/viewspace-712223/