Ask the Expert

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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: