LogMiner 9.0.1 does not show CREATE table
Hi,
Why logminer does not show my CREATE table statement in 8.0.4 database??? Here are the details:
In 8.0.4 database server.
1. as sys, run dbmslmd.sql (copy from 8.1.7 server)
2. as userA,create table dummy as select * from mytab where rownum <=100; (resides in arc_105.log)
3. as sys, switch log file
4. as sys, execute sys.dbms_logmnr_d.build('dictionary.ora','/home/oracle/dba/TRNHDB/log');
In 9.0.1 db server
1. SQL> execute dbms_logmnr.add_logfile(logfilename => '/home/oracle/dba/TRNHDB/log/arc_105.log',options => dbms_logmnr.new);
2. SQL> execute dbms_logmnr.start_logmnr(dictfilename => '/home/oracle/dba/TRNHDB/log/dictionary.ora');
SQL> SELECT sql_redo,sql_undo FROM V$LOGMNR_CONTENTS where seg_owner='USERA';
no rows selected
Why it did not show CREATE table operation from 'USERA' ???? Please advise.
Rgds,
Suhaimi
