DBA_REGISTRY_HIERARCHY

DBA_REGISTRY_HIERARCHY displays information about the components loaded into the database, grouped by owner and organized in the component hierarchy.

Column Datatype NULL Description

NAMESPACE

VARCHAR2(30)

NOT NULL

Component namespace

COMP_ID

VARCHAR2(4000)

  

Component identifier

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