Error using LogMiner, Part 3

I tried your suggestion, but I got another error message as below: 
 
 SQL> CONNECT SYS/ORACLE@DB03 AS SYSDBA
 Connected.
 SQL>  execute
 DBMS_LOGMNR_D.BUILD('db03dict.ora','c:oracleLM');
 BEGIN
 DBMS_LOGMNR_D.BUILD('db03dict.ora','c:oracleLM');
 END;
 
 *
 ERROR at line 1:
 ORA-06532: Subscript outside of limit
 ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
 ORA-06512: at line 1
Please help me out.

    Requires Free Membership to View

    Login

I hate it when you solve one problem and then another comes up!!! Oh well....

This is actually a common problem. Others have experienced the same thing. This is a known bug and should have been fixed in Oracle 8.1.7.2 and higher. But you can fix this without applying a patchset. Simply peform the following:

  1. Navigate to the ORACLE_HOME/rdbms/admin directory.
  2. Load the dbmslmd.sql file into a text editor of your choice.
  3. Change the line:
                
   TYPE col_desc_array IS VARRAY(513) OF
col_description;
    to 
                           
TYPE col_desc_array IS VARRAY(700) OF col_description;
  4. Save the file.
  5. Connect as INTERNAL (or SYS) and run this script again.
  6. Recompile the package body DBMS_LOGMNR_D: 
    SQLPLUS> alter package DBMS_LOGMNR_D compile body;
    That should fix your problem.

    For More Information


    This was first published in December 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top