dbms_registry_sys | package

General Information
Purpose Internal functions used by SYS during upgrade/downgrade
Source {ORACLE_HOME}/rdbms/admin/dbmscr.sql

Dependencies
DBA_SEGMENTS PLITBLM
DBA_TRIGGERS REGISTRY$
DBMS_ASSERT REGISTRY$HISTORY
DBMS_OUTPUT REGISTRY$LOG
DBMS_REGISTRY REGISTRY$SCHEMAS
DBMS_SESSION USER$
DBMS_STATS UTL_FILE
DBMS_SYSTEM V$INSTANCE
DBMS_SYS_ERROR V$OPTION
DUAL X$KSPPCV
OBJ$ X$KSPPI
Security Model Owned by SYS with no granted privileges

CHECK_COMPONENT_DOWNGRADES
Undocumented dbms_registry_sys.check_component_downgrades;
exec dbms_registry_sys.check_component_downgrades;

CPU_SCRIPT
Undocumented dbms_registry_sys.cpu_script(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry_sys.cpu_script('APEX')
FROM dual;

DBDWG_SCRIPT
Returns the name of the script that downgrades the component dbms_registry_sys.dbdwg_script(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry_sys.dbdwg_script('APEX')
FROM dual;

DBUPG_SCRIPT
Returns the name of the script that upgrades the component dbms_registry_sys.dbupg_script(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry_sys.dbupg_script('APEX')
FROM dual;

DIAGNOSTICS
Undocumented dbms_registry_sys.diagnostics RETURN NUMBER;
SELECT dbms_registry_sys.diagnostics
FROM dual;

DROP_USER
One might assume that this can be used to drop a user. One might assume so incorrectly it would seem. dbms_registry_sys,drop_user(username IN VARCHAR2);
SQL> exec dbms_registry_sys.drop_user('MECHID');

PL/SQL procedure successfully completed.

SQL> select username from dba_users where username like 'M%';

USERNAME
------------------------------
MLIB
MGMT_VIEW
MECHID
MDDATA
MDSYS

GATHER_STATS
Undocumented dbms_registry_sys.gather_stats(comp_id IN VARCHAR2); -- Default (NULL) gathers for all components
-- see also {$ORACLE_HOME}/rdbms/admin/cmpupend.sql
exec dbms_registry_sys.gather_stats(NULL);

PATCH_SCRIPT
Returns the name of the script that patches the component dbms_registry_sys.patch_script(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry_sys.patch_script('APEX')
FROM dual;

SELECT dbms_registry_sys.patch_script('XDB')
FROM dual;

POPULATE
Undocumented dbms_registry_sys.populate;
exec dbms_registry_sys.populate;

POPULATE_101
Undocumented dbms_registry_sys.populate_101;
exec dbms_registry_sys.populate_101;

POPULATE_102
Undocumented dbms_registry_sys.populate_102;
exec dbms_registry_sys.populate_102;

POPULATE_92
Undocumented dbms_registry_sys.populate_92;
exec dbms_registry_sys.populate_92;

RECORD_ACTION
Undocumented dbms_registry_sys.record_action(
action    IN VARCHAR2,
action_id IN NUMBER,
comments  IN VARCHAR2);
TBD

RELOD_SCRIPT
Returns the name of the script that reloads the component dbms_registry_sys.relod_script(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry_sys.relod_script('APEX')
FROM dual;

REMOVAL_SCRIPT
Returns the name of the script that removes the component dbms_registry_sys.removal_script(comp_id IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_registry_sys.removal_script('APEX')
FROM dual;

SET_REGISTRY_CONTEXT
Undocumented dbms_registry_sys.set_registry_context(ctx_variable IN VARCHAR2, ctx_value IN VARCHAR2);
TBD

TIME_STAMP
Undocumented dbms_registry_sys.time_stamp(comp_id IN VARCHAR2) RETURN VARCHAR2;
-- see {$ORACLE_HOME}/rdbms/admin/cmpupend.sql. This example collects optimizer stats for all server component schemas

SELECT dbms_registry_sys.time_stamp('STATS_BGN') as timestamp FROM dual;

-- STATS_BGN is not a registry component last time I looked

VALIDATE_CATALOG
Undocumented dbms_registry_sys.validate_catalog;
exec dbms_registry_sys.validate_catalog;

VALIDATE_CATJAVA
Undocumented dbms_registry_sys.validate_catjava;
exec dbms_registry_sys.validate_catjava;

VALIDATE_CATPROC
Undocumented dbms_registry_sys.validate_catproc;
exec dbms_registry_sys.validate_catproc;

VALIDATE_COMPONENTS
Undocumented dbms_registry_sys.validate_components;
exec dbms_registry_sys.validate_components;