log miner

[rommel]

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,

[pando]

serach the forum

[Tarry]

You did run the dbmslmd.sql before setting all that up right?

See for more...http://technet.oracle.com/docs/produ...redo.htm#12680

[rommel]

Thanks Pando, and sorry, I forgot.
I searched "logminer" and got lots of previous post about it.