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

Thread: log miner

  1. #1
    Join Date
    Jan 2002
    Posts
    146

    log miner

    Hi all,

    I'm currently testing the log miner.

    The things to do are:

    1.) Edit the init.ora and specify the log location.
    utl_file_dir = c:\oracle\logs

    2.) Login to system/passwd

    sql> EXECUTE dbms_logmnr_d.build(dictionary_filename =>'dictionary.ora',dictionary_location => 'c:\oracle\logs');

    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

    sql> EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora','c:\oracle\logs', OPTIONS => DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

    ERROR at line 1:
    ORA-06550: line 1, column 73:
    PLS-00201: identifier 'DBMS_LOGMNR_D.STORE_IN_FLAT_FILE' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    What missing in my command?

    Thanks,

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    serach the forum

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    You did run the dbmslmd.sql before setting all that up right?

    See for more...http://technet.oracle.com/docs/produ...redo.htm#12680
    Last edited by Tarry; 05-16-2003 at 04:30 AM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Jan 2002
    Posts
    146
    Thanks Pando, and sorry, I forgot.
    I searched "logminer" and got lots of previous post about it.

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