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

TABLE: DVSYS.REALM_OBJECT$

Object Details
Object Name: REALM_OBJECT$
Object Type: TABLE
Owner: DVSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: REALM_OBJECT$_PK1
  1. ColumnID#
Unique Key: REALM_OBJECT$_UK1
  1. ColumnREALM_ID#
  2. ColumnOWNER_UID#
  3. ColumnOBJECT_NAME
  4. ColumnOBJECT_TYPE
Indexes
Index Type Uniqueness Tablespace Column
REALM_OBJECT$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
REALM_OBJECT$_UK1 NORMAL UNIQUE TablespaceSYSAUX ColumnREALM_ID#
ColumnOWNER_UID#
ColumnOBJECT_NAME
ColumnOBJECT_TYPE
REALM_OBJECT$_FK_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnREALM_ID#
Foreign Keys
Table
Foreign Table Foreign Key Column
REALM_OBJECT$ REALM_OBJECT$_FK TableREALM$ REALM_OBJECT$ REALM_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
REALM_ID# NUMBER
Yes
OWNER VARCHAR2 (128)
OWNER_UID# NUMBER
Yes
OBJECT_NAME VARCHAR2 (128) Yes
OBJECT_TYPE VARCHAR2 (32) Yes
VERSION NUMBER

CREATED_BY VARCHAR2 (128)
CREATE_DATE DATE

UPDATED_BY VARCHAR2 (128)
UPDATE_DATE DATE

Query Text

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


SELECT ID#
,      REALM_ID#
,      OWNER
,      OWNER_UID#
,      OBJECT_NAME
,      OBJECT_TYPE
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.REALM_OBJECT$;

Dependencies

[top of page]

DVSYS.REALM_OBJECT$ does not reference any database object

DVSYS.REALM_OBJECT$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_REALM_OBJECT
ViewDV$REALM_OBJECT
ViewKU$_DV_ISR_VIEW