5.276 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 |
---|---|---|---|
|
|
|
Component identifier |
|
|
|
Component name |
|
|
|
Component version loaded |
|
|
|
Component full version |
|
|
|
Component status:
|
|
|
|
Time when the component was last modified |
|
|
|
Component namespace |
|
|
|
User that created the component entry |
|
|
|
User that contains the objects for the component |
|
|
|
Validation procedure |
|
|
|
Indicates whether the component requires a startup after the upgrade ( |
|
|
|
Parent component identifier |
|
|
|
A list of ancillary schema names associated with the component |
See Also: