DBA_REGISTRY

DBA_REGISTRY displays information about the components loaded into the database.

Related View

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

Column Datatype NULL Description
COMP_ID VARCHAR2(30) NOT NULL Component identifier
COMP_NAME VARCHAR2(255)   Component name
VERSION VARCHAR2(30)   Component version loaded
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(30) NOT NULL User that created the component entry
SCHEMA VARCHAR2(30) 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

See Also:

"USER_REGISTRY"