Oracle LogMiner cannot find the datagram In Memory Undo is unsupported

I recently used LogMiner to mine logs on Oracle 10 Gb. I did not intend to create table test as select * from v $ logmnr_contents. I found that there are actually records, but the recorded content cannot be parsed, the info field reports In Memory Undo is unsupported. After several twists and turns, the attachment log is OK. The following is the reproduction of the experiment:

C: \ Documents ents and Settings \ guogang> sqlplus test/test

SQL> create table tt as select rownum rn from dual connect by rownum <10;
The table has been created.

First lab:

SQL> select to_char (dbms_flashback.get_system_change_number) from dual;
TO_CHAR (DBMS_FLASHBACK.GET_SYSTEM_CHANGE
----------------------------------------
10309235923278

SQL> delete from tt where rn = 1;
One row has been deleted.
SQL> commit;
Submitted.
SQL> select to_char (dbms_flashback.get_system_change_number) from dual;
TO_CHAR (DBMS_FLASHBACK.GET_SYSTEM_CHANGE
----------------------------------------
10309235923281

SQL> alter database add supplemental log data; -- you must add additional logs.

The database has been changed.

 

The second lab:
SQL> select to_char (dbms_flashback.get_system_change_number) from dual;
TO_CHAR (DBMS_FLASHBACK.GET_SYSTEM_CHANGE
----------------------------------------
10309235923453

SQL> delete from tt where rn = 2;
One row has been deleted.
SQL> commit;
Submitted.

SQL> select to_char (dbms_flashback.get_system_change_number) from dual;
TO_CHAR (DBMS_FLASHBACK.GET_SYSTEM_CHANGE
----------------------------------------
10309235923456

C: \ Documents ents and Settings \ guogang> sqlplus/as sysdba;

For more details, please continue to read the highlights on the next page:

Install and use Oracle LogMiner (9i or later)

Oracle 11g LogMiner Experiment

Oracle tool: simple use of LogMiner

Introduction to Oracle LogMiner

Preparation and analysis processes for Oracle 10 Gb LogMiner

1 2 Next Page