R2(30)
UNDO_CHANGE# NUMBER
OPERATION VARCHAR2(32)
TABLE_NAME VARCHAR2(256)
TABLE_OWNER VARCHAR2(32)
ROW_ID VARCHAR2(19)
UNDO_SQL VARCHAR2(4000)
SQL> --授权：grant select any transaction to scott;
SQL> select tid,tname,versions_operation,versions_starttime,versions_endtime,versions_xid
2 from transaction_table
3 versions between timestamp minvalue and maxvalue
4 order by 1,4;
TID TNAME V VERSIONS_STARTTIME VERSIONS_ENDTIME VERSIONS_XID
---------- -------------------- - ---------------------------------------- ---------------------------------------- ----------------
1 Tom I 29-3月 -12 11.22.00 上午 06001F00B9010000
2 Mary I 29-3月 -12 11.22.00 上午 29-3月 -12 11.22.36 上午 06001F00B9010000
2 Mary123 U 29-3月 -12 11.22.36 上午 08000F00B8010000
3 Mike I 29-3月 -12 11.22.36 上午 08000F00B8010000
SQL> select operation,undo_sql
2 from flashback_transaction_query
3 where xid='08000F00B8010000';
SQL> set linesize 150
SQL> col UNDO_SQL for a60
SQL> /
OPERATIO UNDO_SQL
-------- ------------------------------------------------------------
UPDATE update "SCOTT"."TRANSACTION_TABLE" set "TNAME" = 'Mary' wher
e ROWID = 'AAAM6vAAEAAAALtAAB';
INSERT delete from "SCOTT"."TRANSACTION_TABLE" where ROWID = 'AAAM6
vAAEAAAALtAAC';
BEGIN
SQL> update "SCOTT"."TRANSACTION_TABLE" set "TNAME" = 'Mary' where ROWID = 'AAAM6vAAEAAAALtAAB';
已更新 1 行。
SQL> delete from "SCOTT"."TRANSACTION_TABLE" where ROWID = 'AAAM6vAAEAAAALtAAC';
已删除 1 行。
SQL> commit;
提交完成。
SQL> select * from TRANSACTION_TABLE;
TID TNAME
---------- --------------------
1 Tom
2 Mary
|