11gR2中Flashback_transaction_query的undo_sql列為空的解決辦法

tolilong發表於2012-12-03
SQL
11gR2中Flashback_transaction_query的undo_sql列為空的解決辦法，檢視別人的blog之後，自己測試了一下。[@more@]
SQL> select table_name,operation,row_id,undo_sql from flashback_transaction_query where table_name='TT';

TABLE_NAME OPERATION ROW_ID UNDO_SQL
-------------------- -------------------- -------------------- --------------------
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
google之後發現oracle11gR2禁止了supplemental logging
SQL> alter database add supplemental log data;

Database altered.
SQL> insert into tt select * from tt where object_id=12;

1 row created.

SQL> commit;

Commit complete.
SQL> select table_name,operation,row_id,undo_sql from flashback_transaction_query where table_name='TT';

TABLE_NAME OPERATION ROW_ID UNDO_SQL
-------------------- -------------------- -------------------- --------------------
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT UNKNOWN
TT INSERT AAAEojAABAAAK7rAAA delete from "SYS"."TT" where ROWID = 'AAAEojAABAAAK7rAAA';

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24237320/viewspace-1059849/，如需轉載，請註明出處，否則將追究法律責任。

相關文章