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


TABLE: SYS.REGISTRY$SCHEMAS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REGISTRY_SCHEMA_PK
  1. ColumnNAMESPACE
  2. ColumnCID
  3. ColumnSCHEMA#
Indexes
Index Type Uniqueness Tablespace Column
REGISTRY_SCHEMA_PK NORMAL UNIQUE TablespaceSYSTEM ColumnNAMESPACE
ColumnCID
ColumnSCHEMA#
Foreign Keys
Table
Foreign Table Foreign Key Column
REGISTRY$SCHEMAS REGISTRY_SCHEMA_FK TableREGISTRY$ REGISTRY$SCHEMAS NAMESPACE
REGISTRY$SCHEMAS CID
Columns
Name Datatype Length Mandatory Comments
CID VARCHAR2 (30) Yes
NAMESPACE VARCHAR2 (30) Yes
SCHEMA# NUMBER
Yes
Query Text

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


SELECT CID
,      NAMESPACE
,      SCHEMA#
FROM SYS.REGISTRY$SCHEMAS;

Dependencies

[top of page]

SYS.REGISTRY$SCHEMAS does not reference any database object

SYS.REGISTRY$SCHEMAS is referenced by following:

SchemaAPPS
Package BodyAD_ZD_PREP - show dependent code
SchemaSYS
Package BodyDBMS_REGISTRY - show dependent code
Package BodyDBMS_REGISTRY_SYS - show dependent code
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code