Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_REGISTRY
displays information about the components loaded into the database.
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:
| |
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 |