8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for LogMiner

Kaleem Ahmad said...

I find the article useful and specific to the relevant topic. I have encountered an error while executing the statement
EXECUTE Dbms_Logmnr_D.Build( -
dictionary_filename =>'TSH1dict.ora', -
dictionary_location => 'C:\Oracle\Oradata\TSH1\Archive');

I have already set the appropriate path in the init.ora file.

error reads like this
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

Tim... said...


My guess is you are doing this operation from the wrong user. Try it as the SYS or SYSTEM users.

If you have any problems with this it's probably better to ask a question on the forum.



Aamer said...

Hi, Thanks for such an informative article.

I would humbly suggest a very minor mistake which you might have forgotten,

I have tried executing END_LOGMNR procedure, and according to my experience, a semicolon ";" is required in the following line as shown below:



Tim... said...


Thanks for taking the time to point out the typo. It's corrected now. :)



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.