Ask the Expert

Error using LogMiner, Part 2

Thanks for your reply. As per your suggestion, I have tried to sign on as sys and tried to execute. But still I got the error message.
SQL> connect sys/oracle@db03 as sysdba 
('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

    Requires Free Membership to View

This time, you got a different error. So we are making progress! It sounds like your are using LogMiner on a system that has exceeded the expectations of the Oracle developers. But you can fix this.

First, locate the $ORACLE_HOME/rdbms/admin/dbmslmd.sql file. Copy it to a different file so that you can modify it. We'll call this file dbmslmd_new.sql. Find the line that looks like:

TYPE col_desc_array IS VARRAY(513) OF col_description;
Increase the number '513' to a larger number, like '900'. Then, sign on to SQL*Plus as SYS and run this script that you saved. This will increase the size of this array so that you won't run into this problem.

For More Information

This was first published in November 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: