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博客

11gR2中Flashback_transaction_query的undo_sql列为空的解决办法

最新文章