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 last published in December 2002

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close