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


TABLE: SYS.REGISTRY$

Object Details
Object Name: REGISTRY$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REGISTRY_PK
  1. ColumnNAMESPACE
  2. ColumnCID
Indexes
Index Type Uniqueness Tablespace Column
REGISTRY_PK NORMAL UNIQUE TablespaceSYSTEM ColumnNAMESPACE
ColumnCID
Foreign Keys
Table
Foreign Table Foreign Key Column
REGISTRY$ REGISTRY_PARENT_FK TableREGISTRY$ REGISTRY$ NAMESPACE
REGISTRY$ PID
TableREGISTRY$ REGISTRY_PARENT_FK REGISTRY$ REGISTRY$ NAMESPACE
REGISTRY$ PID
TableREGISTRY$DEPENDENCIES DEPENDENCIES_FK REGISTRY$ REGISTRY$DEPENDENCIES NAMESPACE
REGISTRY$DEPENDENCIES CID
TableREGISTRY$DEPENDENCIES DEPENDENCIES_REQ_FK REGISTRY$ REGISTRY$DEPENDENCIES REQ_NAMESPACE
REGISTRY$DEPENDENCIES REQ_CID
TableREGISTRY$PROGRESS REGISTRY_PROGRESS_FK REGISTRY$ REGISTRY$PROGRESS NAMESPACE
REGISTRY$PROGRESS CID
TableREGISTRY$SCHEMAS REGISTRY_SCHEMA_FK REGISTRY$ REGISTRY$SCHEMAS NAMESPACE
REGISTRY$SCHEMAS CID
Columns
Name Datatype Length Mandatory Comments
CID VARCHAR2 (30) Yes
CNAME VARCHAR2 (255)
SCHEMA# NUMBER
Yes
INVOKER# NUMBER
Yes
VERSION VARCHAR2 (30)
STATUS NUMBER
Yes
FLAGS NUMBER
Yes
MODIFIED DATE

PID VARCHAR2 (30)
BANNER VARCHAR2 (80)
VPROC VARCHAR2 (61)
DATE_INVALID DATE

DATE_VALID DATE

DATE_LOADING DATE

DATE_LOADED DATE

DATE_UPGRADING DATE

DATE_UPGRADED DATE

DATE_DOWNGRADING DATE

DATE_DOWNGRADED DATE

DATE_REMOVING DATE

DATE_REMOVED DATE

NAMESPACE VARCHAR2 (30) Yes
ORG_VERSION VARCHAR2 (30)
PRV_VERSION VARCHAR2 (30)
SIGNATURE RAW (20)
EDITION VARCHAR2 (30)
DATE_OPTIONOFF DATE

Query Text

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


SELECT CID
,      CNAME
,      SCHEMA#
,      INVOKER#
,      VERSION
,      STATUS
,      FLAGS
,      MODIFIED
,      PID
,      BANNER
,      VPROC
,      DATE_INVALID
,      DATE_VALID
,      DATE_LOADING
,      DATE_LOADED
,      DATE_UPGRADING
,      DATE_UPGRADED
,      DATE_DOWNGRADING
,      DATE_DOWNGRADED
,      DATE_REMOVING
,      DATE_REMOVED
,      NAMESPACE
,      ORG_VERSION
,      PRV_VERSION
,      SIGNATURE
,      EDITION
,      DATE_OPTIONOFF
FROM SYS.REGISTRY$;

Dependencies

[top of page]

SYS.REGISTRY$ does not reference any database object

SYS.REGISTRY$ is referenced by following:

SchemaAPPS
Package BodyAD_ZD_PREP - show dependent code
SchemaSYS
ViewALL_REGISTRY_BANNERS
ViewDBA_REGISTRY
ViewDBA_REGISTRY_HIERARCHY
Package BodyDBMS_CLUSTDB - show dependent code
Package BodyDBMS_PREUP - show dependent code
Package BodyDBMS_REGISTRY - show dependent code
PL/SQL PackageDBMS_REGISTRY - show dependent code
Package BodyDBMS_REGISTRY_SYS - show dependent code
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code
ViewEXU9XDBUID
ViewUSER_REGISTRY
ProcedureVALIDATE_ORDIM - show dependent code
FunctionVERSION_SCRIPT