ORACLE已安装组件版本信息 DBA_REGISTRY

最新推荐文章于 2024-08-18 10:47:09 发布

allway2

最新推荐文章于 2024-08-18 10:47:09 发布

阅读量1.2k

点赞数

本文链接：https://blog.csdn.net/allway2/article/details/95063454

版权

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