Re: DBMS_JAVA

Papa Piquillo wrote:
> Hi extents:
> The scripts you have to run as sys for oracle 9.2 are:
> @$ORACLE_HOME/javavm/install/initjvm.sql
> @$ORACLE_HOME/xdk/admin/initxml.sql
> @$ORACLE_HOME/xdk/admin/xmlja.sql
> @$ORACLE_HOME/rdbms/admin/catjava.sql
>
> As Paul says you have to increase the java_pool_size (one of the
> scripts hangs if it is small).
>
> Hope it helps.

You just need to run initjvm.sql to install the Java Virtual Machine and all objects associated with it including dbms_java package. It's been like that since release 8i. java_pool_size should be >= 20MB.

Other stuff is optional add-ons.

Regards
/Rauf Received on Tue Jun 27 2006 - 04:04:39 CDT