http://space.itpub.net/26839123/viewspace-720046 （转载）
搜了一下发现有人也遇到了这个问题。上面是连接，为了防止连接过去，我把内容复制了过来。
[@more@]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/30211111/viewspace-1633118/ ，如需转载，请注明出处，否则将追究法律责任。
