DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Log Miner

  1. #1
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Question

    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)




  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    what about the parameter utl_dir_ in the init.ora file?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- 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
  •  


Click Here to Expand Forum to Full Width