Q

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 
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

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

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