-
Hi guys,
I am trying to create Dictionary file, to execute Log Miner - using the statement :
EXECUTE DBMS_LOGMNR_D.BUILD( -
DICTIONARY_FILENAME => 'dictionary.ora', -
DICTIONARY_LOCATION => 'e:\oracle');
The file is getting created but i am getting the following error message:
Error Message
-----------------
error at line 1:
ORA-06532: subscript outside of limit
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
ORA-06512: at line 1.
It is allowing to add Log files to the Dictionary. But after starting Logminer using DBMS_LOGMNR.START_LOGMNR the results in the V$logmnr_contents are in Hexadecimal.
How to sort out this problem?
Regards
(S.Ramji)
-
what about the parameter utl_dir_ in the init.ora file?
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Ramji,
first set the utl_file_dir='D:\blah\blah'
then,
run dbmslmd.sql
then execute the procedure where dictionary_location=that of utl_file_dir.
after that try the add_logfile
then do the rest...
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
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
|