-
Hi folks,
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.
Agasimani
OCP(10g/9i/8i/8)
-
-
Are you using 8i or 9i?
If it is 8i then make sure it is as follows:
init.ora(example)
--------------------
UTL_FILE_DIR=/oracle816/logminer/
execute
---------
SQL> execute DBMS_LOGMNR_D.BUILD('dictionary.ora','/oracle816/logminer/');
Agasimani
OCP(10g/9i/8i/8)
-
oracle has permission to write in that directory ?
Sanjay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|