DBA_REGISTRY

5.278 DBA_REGISTRY

DBA_REGISTRY displays information about all components in the database that are loaded into the component registry.

The component registry tracks components that can be separately loaded into the Oracle Database. When a SQL script loads the PL/SQL packages and other database objects for a component into the database, the script records the component name, status, and version. If scripts are used to upgrade/downgrade the dictionary elements for the component, then those scripts also record status and version information.

Related View

USER_REGISTRY displays information about the components owned by the current user that are loaded into the component registry.

Column	Datatype	NULL	Description
`COMP_ID`	`VARCHAR2(30)`	`NOT NULL`	Component identifier
`COMP_NAME`	`VARCHAR2(255)`		Component name
`VERSION`	`VARCHAR2(30)`		Component version loaded
`VERSION_FULL`	`VARCHAR2(30)`		Component full version
`STATUS`	`VARCHAR2(11)`		Component status: `INVALID` `VALID` `LOADING` `LOADED` `UPGRADING` `UPGRADED` `DOWNGRADING` `DOWNGRADED` `REMOVING` `REMOVED`
`MODIFIED`	`VARCHAR2(20)`		Time when the component was last modified
`NAMESPACE`	`VARCHAR2(30)`	`NOT NULL`	Component namespace
`CONTROL`	`VARCHAR2(128)`	`NOT NULL`	User that created the component entry
`SCHEMA`	`VARCHAR2(128)`	`NOT NULL`	User that contains the objects for the component
`PROCEDURE`	`VARCHAR2(61)`		Validation procedure
`STARTUP`	`VARCHAR2(8)`		Indicates whether the component requires a startup after the upgrade (`REQUIRED`) or not
`PARENT_ID`	`VARCHAR2(30)`		Parent component identifier
`OTHER_SCHEMAS`	`VARCHAR2(4000)`		A list of ancillary schema names associated with the component