-
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
-
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
-
that is a bug... you have to modify the package... go to metalink and search I think it is something with array size
-
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