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

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

See Also:

"USER_REGISTRY"