Q

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.

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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close