Oracle DBMS_REGISTRY
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose API for creating and maintaining registry entries. This is one of those undocumented packages where I feel it essential to warn readers that the demos here are for education purposes only. If you run any of them you may totally destroy your database. Oracle Support is likely not going to bail you out and neither will I.
AUTHID DEFINER
Constants
Name Data Type Value
 General
RELEASE_STATUS VARCHAR2(30) '&C_ORACLE_HIGH_STATUS'
RELEASE_VERSION registry$.version%type '&C_ORACLE_HIGH_VERSION_4_DOTS'
RELEASE_VERSION_FULL registry$.version%type '&C_ORACLE_HIGH_VERSIONFULL'
 Component Hierarchical Constants
IMD_COMPS NUMBER 1
TRM_COMPS NUMBER 2
ALL_COMPS NUMBER 3
Data Types -- Component Hierarchy Type
TYPE comp_list_t IS TABLE OF VARCHAR2(30)
INDEX BY BINARY_INTEGER;

-- Schema List Parameter
TYPE schema_list_t IS TABLE OF VARCHAR2(30);

-- Component dependency Type - table of component IDs
TYPE comp_depend_list_t IS TABLE OF VARCHAR2(30);

-- Component dependency Type - table of component IDs and associated namespaces
TYPE comp_depend_record_t IS RECORD(
cid        VARCHAR2(30),   -- component id
cnamespace VARCHAR2(30));  -- component namespace

TYPE comp_depend_rec IS TABLE OF comp_depend_record_t INDEX BY BINARY_INTEGER;
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_REGISTRY' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_REGISTRY' ORDER BY 1;

Returns 51 objects
Documented No
Exceptions
Error Code Reason
ORA-39702 Database not open for UPGRADE or DOWNGRADE
ORA-39705 Component 'OWB' not found in registry
First Available Not known
Pragmas SUPPLEMENTAL_LOG_DATA(default, NONE);
Registry Entries col comp_id format a9
col comp_name format a35
col schema format a10
col status format a10
col version format a12

SELECT comp_name, comp_id, version, schema, status
FROM dba_registry
ORDER BY 1;

COMP_NAME                           COMP_ID  VERSION      SCHEMA     STATUS
----------------------------------- -------- ------------ ---------- -----------
JServer JAVA Virtual Machine        JAVAVM   23.0.0.0.0   SYS        VALID
OLAP Analytic Workspace             APS      23.0.0.0.0   SYS        VALID
Oracle Database Catalog Views       CATALOG  23.0.0.0.0   SYS        VALID
Oracle Database Java Packages       CATJAVA  23.0.0.0.0   SYS        VALID
Oracle Database Packages and Types  CATPROC  23.0.0.0.0   SYS        VALID
Oracle Database Vault               DV       23.0.0.0.0   DVSYS      VALID
Oracle Label Security               OLS      23.0.0.0.0   LBACSYS    VALID
Oracle OLAP API                     XOQ      23.0.0.0.0   OLAPSYS    VALID
Oracle Real Application Clusters    RAC      23.0.0.0.0   SYS        OPTION OFF
Oracle Text                         CONTEXT  23.0.0.0.0   CTXSYS     VALID
Oracle Workspace Manager            OWM      23.0.0.0.0   WMSYS      VALID
Oracle XDK                          XML      23.0.0.0.0   SYS        VALID
Oracle XML Database                 XDB      23.0.0.0.0   XDB        VALID
Spatial                             SDO      23.0.0.0.0   MDSYS      VALID
Registry Log Query col cid format a12
col errmsg format a12
col namespace format a10
col optime format a36

SELECT * FROM registry$log ORDER BY 1,4;

CID          NAMESPACE   OPERATION OPTIME                               ERRMSG
------------ ---------- ---------- ------------------------------------ ------------
CATPROC      SERVER              3 27-APR-25 11.53.46.929902 AM -07:00  23.8.0.25.04
UTLRP_BGN    SERVER             -1 27-APR-25 12.02.48.568466 PM -07:00
UTLRP_BGN    SERVER             -1 27-APR-25 01.07.37.067723 PM -07:00
UTLRP_BGN    SERVER             -1 09-MAY-25 02.57.17.975731 PM -05:00
UTLRP_END    SERVER             -1 27-APR-25 12.02.48.578723 PM -07:00
UTLRP_END    SERVER             -1 27-APR-25 01.07.38.349510 PM -07:00
UTLRP_END    SERVER             -1 09-MAY-25 02.57.21.787687 PM -05:00
Security Model Owned by SYS with EXECUTE granted to CTXSYS, LBACSYS, MDSYS, WMSYS and XDB and the DATAPATCH_ROLE and EXECUTE_CATALOG_ROLE roles.
Source {ORACLE_HOME}/rdbms/admin/dbmscr.sql
{ORACLE_HOME}/rdbms/admin/prvtcr.plb
Subprograms
CHECK_SERVER_INSTANCE IS_LOADED SCRIPT_PATH
COMP_NAME IS_SERVER_COMPONENT SCRIPT_PREFIX
COUNT_ERRORS_IN_REGISTRY IS_STARTUP_REQUIRED SESSION_NAMESPACE
DELETE_PROGRESS_ACTION IS_STATS_FROM_UPGRADE SET_COMP_NAMESPACE
DOWNGRADED IS_TRACE_EVENT_SET SET_EDITION
DOWNGRADING IS_UPGRADE_RUNNING SET_PROGRESS_ACTION
EDITION IS_VALID SET_PROGRESS_STEP
GET_CONTAINER_NAME LOADED SET_PROGRESS_VALUE
GET_CON_ID LOADING SET_RDBMS_STATUS
GET_DEPENDENT_COMPS NOTHING_SCRIPT SET_REQUIRED_COMPS
GET_DEPENDENT_COMPS_REC NUM_OF_EXADATA_CELLS SET_SESSION_NAMESPACE
GET_PROGRESS_STEP OPTION_OFF STARTUP_COMPLETE
GET_PROGRESS_VALUE PREV_VERSION STARTUP_REQUIRED
GET_REQUIRED_COMPS PREV_VERSION_FULL STATUS
GET_REQUIRED_COMPS_REC REMOVED STATUS_NAME
INVALID REMOVING SUBCOMPONENTS
IS_COMPONENT RESET_VERSION UPDATE_SCHEMA_LIST
IS_DB_CONSOLIDATED RU_APPLY UPGRADED
IS_DB_PDB RU_ROLLBACK UPGRADING
IS_DB_PDB_SEED SCHEMA VALID
IS_DB_ROOT SCHEMA_LIST VERSION
IS_IN_REGISTRY SCHEMA_LIST_STRING VERSION_FULL
IS_IN_UPGRADE_MODE SCRIPT VERSION_GREATER
 
CHECK_SERVER_INSTANCE
Database must be open for upgrade or downgrade for this to be used dbms_registry.check_server_instance;
-- see $ORACLE_HOME/rdbms/admin/cmpupstr.sql
exec dbms_registry.check_server_instance;
     *
ORA-39702: database not open for UPGRADE or DOWNGRADE
 
COMP_NAME
Returns the component name corresponding to a component ID dbms_registry.comp_name(comp_id IN VARCHAR2) RETURN VARCHAR2;
desc registry$

SELECT pid FROM registry$;

-- loaded procedure from $ORACLE_HOME/rdbms/admin/catcr.sql
-- altered to only show the use of this procedure

Warning: Running this code could be fatal to your system.
This demo is here for education purposes only and should not to be run.

PROCEDURE loaded(comp_id IN VARCHAR2) IS
 p_id VARCHAR2(30) := NLS_UPPER(comp_id);
 p_version VARCHAR2(17) := NLS_UPPER(comp_version);
 p_banner VARCHAR2(80) := comp_banner;
BEGIN
  IF exists_comp(p_id) THEN
    IF p_version IS NULL THEN
      SELECT version INTO p_version FROM v$instance;
    END IF;

    IF p_banner IS NULL THEN
      SELECT banner INTO p_banner FROM v$version
      WHERE rownum = 1;

      p_banner:= substr(p_banner, instr(p_banner,'-',1) + 2);
      p_banner:= dbms_registry.comp_name(p_id) || ' Release ' || p_version || ' - ' || p_banner;
    END IF;
  ELSE
    raise NO_COMPONENT;
  END IF;
END loaded;
/
 
COUNT_ERRORS_IN_REGISTRY
Returns the number of errors found in the registry for the identified comp_id dbms_registry.count_errors_in_registry(comp_id IN VARCHAR2) RETURN NUMBER;
SELECT dbms_registry.count_errors_in_registry('SDO')
FROM dual;

DBMS_REGISTRY.COUNT_ERRORS_IN_REGISTRY('SDO')
---------------------------------------------
                                            0
 
DELETE_PROGRESS_ACTION
Undocumented dbms_registry.delete_progress_action(
comp_id IN VARCHAR2,
action  IN VARCHAR2);
TBD
 
DOWNGRADED
Undocumented

The demo, at right, is copied from ?/rdbms/admin/dve122.sql. Not present in 18c or above		 dbms_registry.downgraded(
comp_id     IN VARCHAR2,
old_version IN VARCHAR2 DEFAULT NULL);
exec dbms_registry.downgraded('DV', '12.2.0');
 
DOWNGRADING
Undocumented

The demo, at right, is copied from ?/rdbms/admin/dve122.sql. Not present in 18c or above		 dbms_registry.downgrading(
comp_id    IN VARCHAR2,
old_name   IN VARCHAR2 DEFAULT NULL,
old_proc   IN VARCHAR2 DEFAULT NULL,
old_schema IN VARCHAR2 DEFAULT NULL,
old_parent IN VARCHAR2 DEFAULT NULL);
exec dbms_registry_.downgrading('DV');
 
EDITION
Undocumented and appears to not return a value when run in EE dbms_registry.edition(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT comp_id, comp_name
FROM dba_registry
ORDER BY 1;

SELECT dbms_registry.edition('RAC');

DBMS_REGISTRY.EDITION('RAC')
-----------------------------
 
 
GET_CONTAINER_NAME
No matter the input always returns CDB$ROOT. Entered into BugDB for version 23.1

Note: a negative number cannot be a valid con_id: Opened in BugDB		 dbms_registry.get_container_name(con_id IN container$.con_id#%TYPE)
RETURN obj$.name%TYPE;
SELECT dbms_registry.get_container_name(-22);

DBMS_REGISTRY.GET_CONTAINER_NAME(-22)
-------------------------------------
CDB$ROOT
 
GET_CONT_ID
Returns the con_id of the current container dbms_registry.get_con_id RETURN NUMBER;
SELECT dbms_registry.get_con_id;

GET_CON_ID
----------
         1
 
GET_DEPENDENT_COMPS
Returns a list of dependent components dbms_registry.get_dependent_comps(comp_id IN VARCHAR2)
RETURN dbms_registry.comp_depend_list_t;
SELECT comp_id, comp_name
FROM dba_registry;

DECLARE
 outrec dbms_registry.comp_depend_list_t;
BEGIN
  outrec := dbms_registry.get_dependent_comps('CATJAVA');
END;
/

PL/SQL procedure successfully completed.
 
GET_DEPENDENT_COMPS_REC
Undocumented dbms_registry.get_dependent_comps_rec(comp_id IN VARCHAR2) RETURN comp_depend_rec;
TBD
 
GET_PROGRESS_STEP
Undocumented dbms_registry.get_progress_step(
comp_id IN VARCHAR2,
action  IN VARCHAR2)
RETURN NUMBER;
TBD
 
GET_PROGRESS_VALUE
Undocumented dbms_registry.get_progress_value(
comp_id IN VARCHAR2,
action  IN VARCHAR2)
RETURN NUMBER;
TBD
 
GET_REQUIRED_COMPS
Undocumented dbms_registry.get_required_comps(comp_id IN VARCHAR2)
RETURN dbms_registry.comp_depend_list_t;
SELECT comp_id, comp_name
FROM dba_registry;

DECLARE
 outrec dbms_registry.comp_depend_list_t;
BEGIN
  outrec := dbms_registry.get_required_comps('CATALOG');
END;
/

PL/SQL procedure successfully completed.
 
GET_REQUIRED_COMPS_REC
Undocumented dbms_registry.get_required_comps_rec(
<record> OUT dbms_registry.comp_depend_record_t,
comp_id  IN  VARCHAR2)
RETURN dbms_registry.comp_depend_rec;
TBD
 
INVALID
Mark an item in the registry as invalid dbms_registry.invalid(comp_id IN VARCHAR2);
col comp_id format a10

SELECT comp_id
FROM dba_registry
ORDER BY 1;

DECLARE
 start_time DATE;
 end_time   DATE;
 option_val VARCHAR2(64);
 g_null     CHAR(1);
BEGIN
  BEGIN
    SELECT NULL INTO g_null
    FROM obj$
    WHERE owner#=0 AND name='V$CACHE_TRANSFER';
    -- valid if v$ges_statistics exists
    SELECT value INTO option_val
    FROM v$option
    WHERE parameter = 'Real Application Clusters';
    -- check if RAC option has been linked in
    IF option_val = 'TRUE' THEN
      dbms_registry.valid('RAC');
    ELSE
      dbms_registry.invalid('RAC');
    END IF;
  EXCEPTION
    WHEN NO_DATA_FOUND THEN
      dbms_registry.invalid('RAC');
  END;
END validate;
/

PL/SQL procedure successfully completed.
 
IS_COMPONENT
Determines whether a component id corresponds with a component dbms_registry.is_component(comp_id IN VARCHAR2) RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_registry.is_component('XML') THEN
    dbms_output.put_line('Is a component');
  ELSE
    dbms_output.put_line('Not a component');
  END IF;
END;
/
Is a component

PL/SQL procedure successfully completed.
 
IS_DB_CONSOLIDATED
Returns TRUE if the database is a consolidated database but but this seems to mean a CDB not that it is multi-tenant dbms_registry.is_db_consolidated RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_registry.is_db_consolidated THEN
    dbms_output.put_line('Is multi-tenant');
  ELSE
    dbms_output.put_line('Not a multi-tenant');
  END IF;
END;
/
Is multi-tenant

PL/SQL procedure successfully completed.
 
IS_DB_PDB
Returns TRUE if in a PDB and FALSE if in CDB$ROOT dbms_registry.is_db_pdb RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_registry.is_db_pdb THEN
    dbms_output.put_line('Current container is a PDB');
  ELSE
    dbms_output.put_line('Current container is not a PDB');
  END IF;
END;
/
Current container is not a PDB

PL/SQL procedure successfully completed.
 
IS_DB_PDB_SEED
Returns TRUE if in PDB$SEED and FALSE if in any other container dbms_registry.is_db_pdb_seed RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_registry.is_db_pdb_seed THEN
    dbms_output.put_line('Current container is PDB$SEED');
  ELSE
    dbms_output.put_line('Current container is not PDB$SEED');
  END IF;
END;
/
Current container is not PDB$SEED

PL/SQL procedure successfully completed.

ALTER SESSION SET CONTAINER = PDB$SEED;

Session altered.

set serveroutput on

BEGIN
  IF dbms_registry.is_db_pdb_seed THEN
    dbms_output.put_line('Current container is PDB$SEED');
  ELSE
    dbms_output.put_line('Current container is not PDB$SEED');
  END IF;
END;
/
Current container is not PDB$SEED

PL/SQL procedure successfully completed.
 
IS_DB_ROOT
Returns TRUE if in CDB$ROOT and FALSE if in any other container dbms_registry.is_db_root RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_registry.is_db_root THEN
    dbms_output.put_line('Current container is CDB$ROOT');
  ELSE
    dbms_output.put_line('Current container is not CDB$ROOT');
  END IF;
END;
/
Current container is CDB$ROOT

PL/SQL procedure successfully completed.
 
IS_IN_REGISTRY
Determines whether a component is loaded into the registry dbms_registry.is_in_registry(comp_id IN VARCHAR2) RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_registry.is_in_registry('XML') THEN
    dbms_output.put_line('Is in the registry');
  ELSE
    dbms_output.put_line('Not in the registry');
  END IF;
END;
/
Is in the registry

PL/SQL procedure successfully completed.
 
IS_IN_UPGRADE_MODE
Definitely returns FALSE if not in upgrade mode. Have not tested to determine if it returns TRUE or nothing when actually in upgrade mode dbms_registry.is_in_upgrade_mode RETURN BOOLEAN;
conn / as sysdba

set serveroutput on

BEGIN
  IF dbms_registry.is_in_upgrade_mode THEN
    dbms_output.put_line('In Upgrade Mode');
  ELSE
    dbms_output.put_line('Not In Upgrade Mode');
  END IF;
END;
/
 
IS_LOADED
Returns 1 if the componenet version number matches the name-value pair submitted: Otherwise 0 dbms_registry.is_loaded(
comp_id IN VARCHAR2,
version IN VARCHAR2 DEFAULT NULL)
RETURN NUMBER;
SELECT comp_id, version
FROM dba_registry;

SELECT dbms_registry.is_loaded('XML', '20.3.0.0.1');
 
IS_SERVER_COMPONENT
Returns 1 if the component name is a server component, else 0 dbms_registry.is_server_component(comp_id VARCHAR2) RETURN NUMBER DETERMINISTIC;
SELECT dbms_registry.is_server_component('RAC');
 
IS_STARTUP_REQUIRED
Returns whether a registry component requires a startup dbms_registry.is_startup_required(comp_id IN VARCHAR2) RETURN NUMBER;
SELECT comp_id, procedure, startup
FROM dba_registry;

SELECT dbms_registry.is_startup_required('XML');
 
IS_STATS_FROM_UPGRADE
Undocumented dbms_registry.is_stats_from_upgrade RETURN BOOLEAN;
BEGIN
  IF dbms_registry.is_stats_from_upgrade THEN
    dbms_output.put_line('Yes');
  ELSE
    dbms_output.put_line('No');
  END IF;
END;
/
 
IS_TRACE_EVENT_SET
Undocumented but the behavior is not   expected. This has been reported to BugDB. dbms_registry.is_trace_event_set(trace_event VARCHAR2) RETURN BOOLEAN;
BEGIN
  IF dbms_registry.is_trace_event_set('10046') THEN
    dbms_output.put_line('10046 Trace Is Set');
  ELSE
    dbms_output.put_line('Trace Is Not Set');
  END IF;
END;
/
*
ORA-01403: no data found
 
IS_UPGRADE_RUNNING
Returns TRUE if an upgrade is in progress dbms_registry.is_upgrade_running RETURN BOOLEAN;
BEGIN
  IF dbms_registry.is_supgrade_running THEN
    dbms_output.put_line('Upgrade Running');
  ELSE
    dbms_output.put_line('Upgrade Not Running');
  END IF;
END;
/
 
IS_VALID
Determines if a registry component is valid dbms_registry.is_valid(
comp_id IN VARCHAR2,
version IN VARCHAR2 DEFAULT NULL)
RETURN NUMBER;
BEGIN
  IF dbms_registry.is_valid('JAVAVM', dbms_registry.release_version) =1 THEN
    dbms_registry.loaded('CATJAVA');
    dbms_registry_sys.validate_catjava;
  END IF;
END;
/
 
LOADED
Indicate load complete dbms_registry.loaded(
comp_id      IN VARCHAR2,
comp_version IN VARCHAR2 DEFAULT NULL,
comp_banner  IN VARCHAR2 DEFAULT NULL);
exec dbms_registry.loaded('CATALOG');
 
LOADING
Indicate that the component is in the process of being loaded

Overload 1		 dbms_registry.loading(
comp_id     IN VARCHAR2,
comp_name   IN VARCHAR2,
comp_proc   IN VARCHAR2 DEFAULT NULL,
comp_schema IN VARCHAR2 DEFAULT NULL,
comp_parent IN VARCHAR2 DEFAULT NULL);
set linesize 121
col comp_name format a35
col procedure format a35
col schema format a10
col parent_id format a10

SELECT comp_id, comp_name, procedure, schema, parent_id
FROM dba_registry;

BEGIN
  dbms_registry.loading('CATALOG', 'Oracle Database Catalog Views', 'dbms_registry_sys.validate_catalog');
END;
/
Overload 2 dbms_registry.loading(
comp_id      IN VARCHAR2,
comp_name    IN VARCHAR2,
comp_proc    IN VARCHAR2,
comp_schema  IN VARCHAR2,
comp_schemas IN dbms_registry.schema_list_t,
comp_parent  IN VARCHAR2 DEFAULT NULL);
TBD
 
NOTHING_SCRIPT
Returns the path to nothing.sql dbms_registry.nothing_script RETURN VARCHAR2;
SELECT dbms_registry.nothing_script;
 
NUM_OF_EXADATA_CELLS
Returns the number of Exadata cells dbms_registry.num_of_exadata_cells RETURN NUMBER;
SELECT dbms_registry.num_of_exadata_cells;
 
OPTION_OFF
Disables a component option in the registry.

Warning: We are not aware of any method of re-enabling an option so don't do this except in a throw-away training database.		 dbms_registry.option_off(comp_id IN VARCHAR2);
SELECT comp_id, comp_name, status, startup
FROM dba_registry
ORDER BY 1;

exec dbms_registry.option_off('ORDIM');

SELECT comp_id, comp_name, status, startup
FROM dba_registry
ORDER BY 1;
 
PREV_VERSION
Returns the previous version of a registry component dbms_registry.prev_version(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.prev_version('XML');
 
PREV_VERSION_FULL
Returns the previous full version number string dbms_registry.prev_version_full(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.prev_version_full('RAC');
 
REMOVED
A component has been removed from the registry dbms_registry.removed(comp_id IN VARCHAR2);
exec dbms_registry.removed('EXF');
 
REMOVING
Removes a component from the registry dbms_registry.removing(comp_id IN VARCHAR2);
-- drop the Expression Filter user with cascade option
exec dbms_registry.removing('EXF');

DROP USER exfsys CASCADE;
 
RESET_VERSION
Undocumented dbms_registry.reset_version(comp_id IN VARCHAR2);
exec dbms_registry.reset_version('APS');
 
RU_APPLY
Undocumented dbms_registry.ru_apply(
comp_version      IN VARCHAR2  DEFAULT NULL,
build_description IN VARCHAR2  DEFAULT NULL,
build_timestamp   IN TIMESTAMP DEFAULT NULL);
TBD
 
RU_ROLLBACK
Undocumented dbms_registry.ru_rollback(
comp_version      IN VARCHAR2  DEFAULT NULL,
build_description IN VARCHAR2  DEFAULT NULL,
build_timestamp   IN TIMESTAMP DEFAULT NULL);
TBD
 
SCHEMA
Returns the schema owner of a registry component dbms_registry.schema(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.schema('EXF');
 
SCHEMA_LIST
Returns the schema owners of a registry component dbms_registry.schema_list(comp_id IN VARCHAR2) RETURN dbms_registry.schema_list_t;
TBD
 
SCHEMA_LIST_STRING
Undocumented dbms_registry.schema_list_string(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.schema_list_string('EXF');
 
SCRIPT
Undocumented dbms_registry.script(
comp_id     IN VARCHAR2,
script_name IN VARCHAR2)
RETURN VARCHAR2;
-- create helper package for text index on xdb resource data
COLUMN xdb_name NEW_VALUE xdb_file NOPRINT;

SELECT dbms_registry.script('CONTEXT','@dbmsxdbt.sql') AS xdb_name;
 
SCRIPT_PATH
Returns the path to the script for a registry component dbms_registry.script_path(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.script_path('EXF');
 
SCRIPT_PREFIX
Returns a registry component's prefix dbms_registry.script_prefix(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.script_prefix('EXF');
 
SESSION_NAMESPACE
Returns the namespace for a session dbms_registry.session_namespace RETURN VARCHAR2;
SELECT dbms_registry.session_namespace;
 
SET_COMP_NAMESPACE
Sets a registry component's namespace dbms_registry.set_comp_namespace(
comp_id   IN VARCHAR2,
namespace IN VARCHAR2);
exec dbms_registry.set_comp_namespace('RAC', 'SERVER');
 
SET_EDITION
Sets Database Edition: EE or SE
Overload 1		 dbms_registry.set_edition(comp_id IN VARCHAR2);
exec dbms_registry.set_edition('ORDIM');
Overload 2 dbms_registry.set_edition(
comp_id     IN VARCHAR2,
edition_var IN VARCHAR2);
exec dbms_registry.set_edition('ORDIM', 'EE');
 
SET_PROGRESS_ACTION
Undocumented dbms_registry.set_progress_action(
comp_id IN VARCHAR2,
action  IN VARCHAR2,
value   IN VARCHAR2 DEFAULT NULL,
step    IN NUMBER   DEFAULT NULL);
TBD
 
SET_PROGRESS_STEP
Undocumented dbms_registry.set_progress_step(
comp_id IN VARCHAR2,
action  IN VARCHAR2,
step    IN NUMBER);
TBD
 
SET_PROGRESS_VALUE
Undocumented dbms_registry.set_progress_value(
comp_id IN VARCHAR2,
action  IN VARCHAR2,
value   IN VARCHAR2);
TBD
 
SET_RDBMS_STATUS
Sets the component status in the registry

1 = VALID		 dbms_registry.set_rdbms_status(
comp_id IN VARCHAR2,
status  IN NUMBER);
SELECT status
FROM dba_registry
WHERE comp_id = 'ORDIM';

exec dbms_registry.set_rdbms_status('ORDIM', 1);
 
SET_REQUIRED_COMPS
Undocumented

Overload 1		 dbms_registry.set_required_comps(
comp_id          IN VARCHAR2,
comp_depend_list IN comp_depend_list_t);
TBD
Overload 2 dbms_registry.set_required_comps(
comp_id          IN VARCHAR2,
comp_depend_list IN comp_depend_rec);
TBD
 
SET_SESSION_NAMESPACE
Sets the registry namespace for a component dbms_registry.set_session_namespace(namespace IN VARCHAR2);
exec dbms_registry.set_session_namespace('SERVER');
 
STARTUP_COMPLETE
Undocumented dbms_registry.startup_complete(comp_id IN VARCHAR2);
exec dbms_registry.startup_complete('RAC');
 
STARTUP_REQUIRED
Updates the registry to indicate that a component requires startup dbms_registry.startup_required(comp_id IN VARCHAR2);
exec dbms_registry.startup_required('OLS');
 
STATUS
Determine the status of a database component from the registry dbms_registry.status(comp_id IN VARCHAR2) RETURN VARCHAR2;
BEGIN
  IF dbms_registry.status('CATJAVA') IS NULL THEN
    RAISE_APPLICATION_ERROR(-20000, 'CATJAVA has not been loaded.');
  END IF;
END;
/

BEGIN
  IF dbms_registry.status('XDB') = 'VALID' THEN
    execute immediate 'create table xdb.migr9202status (n integer)';
    execute immediate 'insert into xdb.migr9202status values (1000)';
  END IF;
END;
/
 
STATUS_NAME
Undocumented dbms_registry.status_name(status IN NUMBER) RETURN VARCHAR2;
SELECT dbms_registry.status_name(1);

SELECT dbms_registry.status_name(0);

SELECT dbms_registry.status_name(-1);
 
SUBCOMPONENTS
Undocumented dbms_registry.subcomponents(
comp_id     IN VARCHAR2,
comp_option IN NUMBER   DEFAULT 1,
RETURN dbms_registry.comp_list_t;
TBD
 
UPDATE_SCHEMA_LIST
Undocumented dbms_registry.update_schema_list(
comp_id      IN VARCHAR2,
comp_schemas IN dbms_registry.schema_list_t);
set serveroutput on

-- indicate CATPROC load complete and check validity
BEGIN
  dbms_registry.update_schema_list('CATPROC', dbms_registry.schema_list_t('SYSTEM', 'OUTLN', 'DBSNMP'));
  dbms_registry.loaded('CATPROC');
  dbms_registry_sys.validate_catproc;
  dbms_registry_sys.validate_catalog;
END;
/
 
UPGRADED
Undocumented

The demo, at right, is copied from ?/rdbms/admin/exfcpu.sql		 dbms_registry.upgraded(
comp_id     IN VARCHAR2,
new_version IN VARCHAR2 DEFAULT NULL,
new_banner  IN VARCHAR2 DEFAULT NULL);
ALTER SESSION SET CURRENT_SCHEMA = EXFSYS;

execdbms_registry.upgrading('EXF');

-- insert script invocations required to apply the CPU to the component

exec dbms_registry.upgraded('EXF');

ALTER SESSION SET CURRENT_SCHEMA = SYS;
 
UPGRADING
Undocumented

Overload 1		 dbms_registry.upgrading(
comp_id    IN VARCHAR2,
new_name   IN VARCHAR2 DEFAULT NULL,
new_proc   IN VARCHAR2 DEFAULT NULL,
new_schema IN VARCHAR2 DEFAULT NULL,
new_parent IN VARCHAR2 DEFAULT NULL);
See Upgraded Demo Above
Overload 2 dbms_registry.upgrading(
comp_id     IN VARCHAR2,
new_name    IN VARCHAR2,
new_proc    IN VARCHAR2,
new_schema  IN VARCHAR2,
new_schemas IN dbms_registry.schema_list_t,
new_parent  IN VARCHAR2 DEFAULT NULL);
See Upgraded Demo Above
 
VALID
Mark an item in the registry as valid dbms_registry.valid(comp_id IN VARCHAR2);
See INVALID Demo Above
 
VERSION
Returns the version of a registry component dbms_registry.version(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.version('CATPROC');
VERSION_FULL
Undocumented dbms_registry.version_full(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry.version_full('XML');
 
VERSION_GREATER
Undocumented dbms_registry.version_greater(
left_version  IN VARCHAR2,
right_version IN VARCHAR2)
RETURN BOOLEAN;
TBD

Related Topics
Built-in Functions
Built-in Packages
Container Database
DBMS_REGISTRY_EXTENDED
DBMS_REGISTRY_SERVER
DBMS_REGISTRY_SIMPLE
DBMS_REGISTRY_SYS
Seed Database
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved