Static Data Dictionary Views, 351 of 666

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
`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
`PARENT_ID`	`VARCHAR2(30)`		Parent component identifier

See Also:

"USER_REGISTRY"