实例:
1、
查询表t中的数据
SQL> select * from t;
ID
----------
1
1、
查询表t中的数据
SQL> select * from t;
ID
----------
1
2、
修改表中的一行数据
SQL> insert into t values(10);
1 row insertd.
SQL> commit;
Commit complete.
3、
SQL> select * from t;
修改表中的一行数据
SQL> insert into t values(10);
1 row insertd.
SQL> commit;
Commit complete.
3、
SQL> select * from t;
ID
----------
1
10
4、
闪回事物查询
select xid,operation,commit_scn,undo_sql from flashback_transaction_query where xid in (
select versions_xid from t versions between scn minvalue and maxvalue);
XID OPERATION COMMIT_SCN UNDO_SQL
---------------- -------------------------------- ---------- --------------------------------------------------
0A00130035010000 INSERT 701803 delete from "HR"."T" where ROWID = 'AAAM6DAAEAAAAG
uAAC';
----------
1
10
4、
闪回事物查询
select xid,operation,commit_scn,undo_sql from flashback_transaction_query where xid in (
select versions_xid from t versions between scn minvalue and maxvalue);
XID OPERATION COMMIT_SCN UNDO_SQL
---------------- -------------------------------- ---------- --------------------------------------------------
0A00130035010000 INSERT 701803 delete from "HR"."T" where ROWID = 'AAAM6DAAEAAAAG
uAAC';
0A00130035010000 BEGIN 701803
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29107230/viewspace-769174/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29107230/viewspace-769174/