When i am trying to use log miner i am getting the followin error
SVRMGR> execute dbms_logmnr_d.build('dict.ora','/ora/data/prod/logm');
ORA-01309: specified dictionary file cannot be opened
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
ORA-06512: at line 2
could anybody help me
Make sure the value you have specified for the second parameter of BUILD procedure is same as the value of UTL_FILE_DIR of init.ora.
Are you using 8i or 9i?
If it is 8i then make sure it is as follows:
SQL> execute DBMS_LOGMNR_D.BUILD('dictionary.ora','/oracle816/logminer/');
oracle has permission to write in that directory ?
Click Here to Expand Forum to Full Width