Oracle Audio Technologies Retail Data Warehouse 13 User Manual
Page 31
Install Oracle Configuration Manager
Database Installation Guide 23
GROUP 3 ('
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
UNDO TABLESPACE undo_ts DATAFILE '
SYSAUX DATAFILE '
MAXSIZE 2000M
;
exit
spool off
----------------------------------------------------------------------------------
---
--- Script: crdb2.sql
--- Execute as: sysdba in 10.1.0.2 databases or higher
--- Note: This script installs the data dictionary views in addition to
--- granting necessary privileges to public.
----------------------------------------------------------------------------------
---
spool crdb2.log
REM # install data dictionary views:
PROMPT Running catalog.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql;
PROMPT Running catblock.sql
@$ORACLE_HOME/rdbms/admin/catblock.sql;
PROMPT Running catproc.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql;
PROMPT Running catoctk.sql
@$ORACLE_HOME/rdbms/admin/catoctk.sql;
PROMPT Running catrep.sql
@$ORACLE_HOME/rdbms/admin/catrep.sql;
PROMPT Running owminst.plb
@$ORACLE_HOME/rdbms/admin/owminst.plb;
REM * These privs needed for users to run proper grant code when creating users.
grant select on dba_jobs to public with grant option;
grant select on dba_roles to public with grant option;
grant select on dba_role_privs to public with grant option;
grant execute on dbms_rls to public with grant option;
grant execute on dbms_alert to public;
grant select_catalog_role to public;
grant execute_catalog_role to public;
grant execute on dbms_lock to public;
grant execute on dbms_rls to public;
grant execute on dbms_crypto to public;
grant select on dba_sys_privs to public with grant option;
REM * query rewrite privilege needed to create function-based indexes
grant query rewrite to public;
REM * dbms_system is needed for tracing
grant execute on sys.dbms_system to public;
PROMPT Creating PLAN table owned by SYSTEM
@$ORACLE_HOME/rdbms/admin/utlxplan.sql
PROMPT Creating public synonyn for the plan table
create public synonym PLAN_TABLE for SYSTEM.PLAN_TABLE;
connect SYSTEM/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql;