how to create the dbms_java package

 if you create a set of scripts using the dbca then there should be one
looking basically like this:

@?/javavm/install/initjvm.sql;
@?/xdk/admin/initxml.sql;
@?/xdk/admin/xmlja.sql;
@?/rdbms/admin/catjava.sql;
@?/rdbms/admin/catexf.sql;

Ok, this is for 10g, but I think it was pretty similar for 9i.

After these scripts have run (connect / as sysdba and have the DB for
yourself without users logged in) you should have the dbms_java package.
You can check that with the sqlplus describe command.

Don't forget to set java_pool_size and (I think) large_pool_size to
something like 150M each during installation. Also bounce the instance
after installation and run ?/rdbms/admin/utlrp.

 

 

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

 - THE END -

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11417069/viewspace-684275/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11417069/viewspace-684275/