Re: LogMiner raises ORA-06532 :(

A quick search on metalink suggests to "tweak" the dbmslmd.sql script,

replace ==> TYPE col_desc_array IS VARRAY(513) OF col_description; with ==> TYPE col_desc_array IS VARRAY(700) OF col_description;

700 -> Guess work; Probably set it to a number greater than the max(no. of columns) of table owned in the min'ed database.

HTH.,
Regards.

ORA-600 ( ora600 at users d0t sourceforge d0t net )

"Thomas Mellenthin" <melle_at_potsdam.de> wrote in message news:9v39m9.nbi.ln_at_haeckse.ebola...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hallo,
>
> im running into trouble using the logminer.
> The creation of the dictionary-file fails:
>
> SQL> EXECUTE DBMS_LOGMNR_D.BUILD('v817dict.ora','e:\oracle');
> BEGIN DBMS_LOGMNR_D.BUILD('v817dict.ora','e:\oracle'); 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
>
> The UTL_FILE_DIR is set to e:\oracle
>
> I'm using Oracle 8.1.7 EE on Windows 2000 and
> on Linux 2.4.4, the problem occurs on both systems.
>
>
> Any help would be appreciated :)
>
>
> // t. mellenthin
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.1i for non-commercial use <http://www.pgpi.com/>
> Comment: public key: http://www.mellenthin.de/contact/
>
> iQA/AwUBO4gCOtxO0G1BGu68EQKTfACgh+245xlTvL8cBd6JSLA7efwAUZ8AoIGI
> irLqK4vLwUTdpqTgqi1XCvgs
> =KUoa
> -----END PGP SIGNATURE-----
>
>
>
Received on Sun Aug 26 2001 - 02:48:16 CDT