LogMiner Utility in Ora 8i

[sharmila]

While working with Logminer Utility ,i have faced a problem while initially creating a dictionary file, using the DBMS_LOGMNR_D.build ( ....) the error that is returned is

ORA6532 Subscript outside of limit

How could i fix this problem

Could anyone out there help me please??

regards,

sharmila

[Tarry]

in the dbms utility
dbmslmd.sql the type is standard
TYPE col_desc_array IS VARRAY(513) OF col_description;
try to increase this value.
I didn't have a problem with it myself.

cheers!!

Tarry

[pando]

that is a bug... you have to modify the package... go to metalink and search I think it is something with array size

[ronnie]

It is a bug in 8i and fixed in 9i. The workaround is

Edit the file "dbmslmd.sql" located in the "$ORACLE_HOME/rdbms/admin"
directory.

Change the line:

TYPE col_desc_array IS VARRAY(513) OF col_description;

to

TYPE col_desc_array IS VARRAY(700) OF col_description;

and rerun the modified script as internal