Oracle 11g Flashback_transaction_query的undo_sql列为空
SQL> select table_name,operation,row_id,undo_sql
from flashback_transaction_query where table_name='TEST' ;
TABLE_NAME OPERATION ROW_ID UNDO_SQL
---------- ---------- ---------- --------------------------------------------------
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
12 rows selected
goole后，原来Oracle11g禁用了supplemental logging
开启后恢复正常：
|
alter database add supplemental log data; |
SQL> alter database add supplemental log data;
Database altered
SQL> select * from test;
ID XM
---------- ----------
1 李山
2 杨晓
SQL> delete test where id=1;
1 row deleted
SQL> select table_name,operation,row_id,undo_sql
from flashback_transaction_query where table_name='TEST';
TABLE_NAME OPERATION ROW_ID UNDO_SQL
---------- ---------- ---------- --------------------------------------------------
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST DELETE AAAR9YAAFA insert into "ADMIN"."TEST"("ID","XM") values ('1',
AAACDAAA '李山');
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
TEST UNKNOWN
13 rows selected
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26839123/viewspace-720046/ ，如需转载，请注明出处，否则将追究法律责任。
