| 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;
/
|
Free