General |
Contains constants used to identify
server components and the associated upgrade/downgrade/patch/reload scripts. |
Source |
{ORACLE_HOME}/rdbms/admin/catcrsc.sql |
Pathname Constants |
Name |
Data Type |
Value |
AMD_path |
VARCHAR2(50) |
'?/olap/admin/'; |
APEX_path |
VARCHAR2(50) |
'?/apex/'; |
APS_path |
VARCHAR2(50) |
'?/olap/admin/'; |
CATJAVA_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
CONTEXT_path |
VARCHAR2(50) |
'?/ctx/admin/'; |
DV_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
EM_path |
VARCHAR2(50) |
'?/sysman/admin/emdrep/sql/'; |
EXF_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
JAVAVM_path |
VARCHAR2(50) |
'?/javavm/install/'; |
MGW_path |
VARCHAR2(50) |
'?/mgw/admin/'; |
ODM_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
OLS_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
ORDIM_path |
VARCHAR2(50) |
'?/ord/im/admin/'; |
OWM_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
RAC_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
RUL_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
SDO_path |
VARCHAR2(50) |
'?/md/admin/'; |
WK_path |
VARCHAR2(50) |
'?/ultrasearch/admin/'; |
XDB_path |
VARCHAR2(50) |
'?/rdbms/admin/'; |
XML_path |
VARCHAR2(50) |
'?/xdk/admin/'; |
XOQ_path |
VARCHAR2(50) |
'?/olap/admin/'; |
|
Prefix Constants |
Name |
Data Type |
Value |
AMD_prefix |
VARCHAR2(3) |
'amd'; |
APEX_prefix |
VARCHAR2(3) |
'apx'; |
APS_prefix |
VARCHAR2(3) |
'aps'; |
CATJAVA_prefix |
VARCHAR2(3) |
'jav'; |
CONTEXT_prefix |
VARCHAR2(3) |
'ctx'; |
DV_prefix |
VARCHAR2(3) |
'dv'; |
EM_prefix |
VARCHAR2(3) |
'em'; |
EXF_prefix |
VARCHAR2(3) |
'exf'; |
JAVAVM_prefix |
VARCHAR2(3) |
'jvm'; |
MGW_prefix |
VARCHAR2(3) |
'mgw'; |
ODM_prefix |
VARCHAR2(3) |
'odm'; |
OLS_prefix |
VARCHAR2(3) |
'ols'; |
ORDIM_prefix |
VARCHAR2(3) |
'im'; |
OWM_prefix |
VARCHAR2(3) |
'owm'; |
RAC_prefix |
VARCHAR2(3) |
NULL; |
RUL_prefix |
VARCHAR2(3) |
'rul'; |
SDO_prefix |
VARCHAR2(3) |
'sdo'; |
WK_prefix |
VARCHAR2(3) |
'wk'; |
XDB_prefix |
VARCHAR2(3) |
'xdb'; |
XML_prefix |
VARCHAR2(3) |
'xml'; |
XOQ_prefix |
VARCHAR2(3) |
'xoq'; |
|
Required Option Names |
Name |
Data Type |
Value |
AMD_option |
VARCHAR2(30) |
'OLAP'; |
APEX_option |
VARCHAR2(30) |
NULL; |
APS_option |
VARCHAR2(30) |
'OLAP'; |
CATJAVA_option |
VARCHAR2(30) |
NULL; |
CONTEXT_option |
VARCHAR2(30) |
NULL; |
DV_option |
VARCHAR2(30) |
'Oracle Label Security'; |
EM_option |
VARCHAR2(30) |
NULL; |
EXF_option |
VARCHAR2(30) |
NULL; |
JAVAVM_option |
VARCHAR2(30) |
'Java'; |
MGW_option |
VARCHAR2(30) |
NULL; |
ODM_option |
VARCHAR2(30) |
'Data Mining'; |
OLS_option |
VARCHAR2(30) |
'Oracle Label Security'; |
ORDIM_option |
VARCHAR2(30) |
NULL; |
OWM_option |
VARCHAR2(30) |
NULL; |
RAC_option |
VARCHAR2(30) |
NULL; |
RUL_option |
VARCHAR2(30) |
NULL; |
SDO_option |
VARCHAR2(30) |
'Spatial'; |
WK_option |
VARCHAR2(30) |
NULL; |
XDB_option |
VARCHAR2(30) |
NULL; |
XML_option |
VARCHAR2(30) |
NULL; |
XOQ_option |
VARCHAR2(30) |
'OLAP'; |
|
Data Type |
TYPE component_table IS TABLE OF VARCHAR2(30);
/
|
Dependencies |
STANDARD
|
Security Model |
Execute is not granted
|
|
Demo |
/rdbms/admin/cmpdbmig.sql |
Rem =====================================================================
Rem Upgrade Intermedia
Rem =====================================================================
SELECT dbms_registry_sys.dbupg_script('ORDIM') AS dbmig_name
FROM DUAL;
@&dbmig_file
Rem If Spatial upgrade,
Rem first install ORDIM if it is not loaded
BEGIN
IF dbms_registry.is_loaded('ORDIM') IS NULL AND
dbms_registry.is_loaded('SDO') IS NOT NULL THEN
:dbinst_name := dbms_registry_server.ORDIM_path || 'imupins.sql';
EXECUTE IMMEDIATE 'CREATE USER si_informtn_schema IDENTIFIED BY
ordsys ' || 'ACCOUNT LOCK PASSWORD EXPIRE ' || 'DEFAULT TABLESPACE
SYSAUX';
ELSE
:dbinst_name := dbms_registry.nothing_script;
END IF;
END;
/
|