Oracle Audio Technologies 13 Benutzerhandbuch

Seite von 35
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