DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.DBA_SERVER_REGISTRY

Object Details
Object Name: DBA_SERVER_REGISTRY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMP_ID VARCHAR2 (30) Yes
COMP_NAME VARCHAR2 (255)
VERSION VARCHAR2 (30)
STATUS VARCHAR2 (11)
MODIFIED VARCHAR2 (20)
CONTROL VARCHAR2 (128) Yes
SCHEMA VARCHAR2 (128) Yes
PROCEDURE VARCHAR2 (61)
STARTUP VARCHAR2 (8)
PARENT_ID VARCHAR2 (30)
OTHER_SCHEMAS VARCHAR2 (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COMP_ID
,      COMP_NAME
,      VERSION
,      STATUS
,      MODIFIED
,      CONTROL
,      SCHEMA
,      PROCEDURE
,      STARTUP
,      PARENT_ID
,      OTHER_SCHEMAS
FROM SYS.DBA_SERVER_REGISTRY;

Dependencies

[top of page]

SYS.DBA_SERVER_REGISTRY references the following:

SchemaSYS
ViewDBA_REGISTRY
PL/SQL PackageDBMS_REGISTRY - show dependent code
SYS.DBA_SERVER_REGISTRY is referenced by following:

SchemaPUBLIC
SynonymDBA_SERVER_REGISTRY