Hi all,

I'm currently testing the log miner.

The things to do are:

1.) Edit the init.ora and specify the log location.
utl_file_dir = c:\oracle\logs

2.) Login to system/passwd

sql> EXECUTE dbms_logmnr_d.build(dictionary_filename =>'dictionary.ora',dictionary_location => 'c:\oracle\logs');

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_LOGMNR_D.BUILD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

sql> EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora','c:\oracle\logs', OPTIONS => DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

ERROR at line 1:
ORA-06550: line 1, column 73:
PLS-00201: identifier 'DBMS_LOGMNR_D.STORE_IN_FLAT_FILE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


What missing in my command?

Thanks,