Oracle Audio Technologies Retail Data Warehouse 13 - Manual (Page 32)

Appendix: Oracle 10g Database Creation Scripts
24 Oracle Retail Data Warehouse
spool off
exit
----------------------------------------------------------------------------------
---
--- Script: crdb3.sql
--- Execute as: sysdba in 10.1.0.2 databases or higher
--- Note: This script installs java and xml components;
--- Do not change the order of the statements below due to
dependencies
----------------------------------------------------------------------------------
---
spool JServer.log
@$ORACLE_HOME/javavm/install/initjvm.sql;
@$ORACLE_HOME/xdk/admin/initxml.sql;
@$ORACLE_HOME/xdk/admin/xmlja.sql;
@$ORACLE_HOME/rdbms/admin/catjava.sql;
@$ORACLE_HOME/rdbms/admin/catexf.sql;
spool off
spool context.log
@$ORACLE_HOME/ctx/admin/catctx change_on_install SYSAUX TEMP NOLOCK;
connect CTXSYS/change_on_install
@$ORACLE_HOME/ctx/admin/defaults/dr0defin.sql AMERICAN;
spool off
spool xdb_protocol.log
connect / as sysdba
@$ORACLE_HOME/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP;
spool off
@$ORACLE_HOME/rdbms/admin/utlrp.sql