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

TABLE: DVSYS.REALM$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: REALM$_PK1
  1. ColumnID#
Indexes
Index Type Uniqueness Tablespace Column
REALM$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
Foreign Keys
Table
Foreign Table Foreign Key Column
TableREALM_AUTH$ REALM_AUTH$_FK REALM$ REALM_AUTH$ REALM_ID#
TableREALM_OBJECT$ REALM_OBJECT$_FK REALM$ REALM_OBJECT$ REALM_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
ENABLED VARCHAR2 (1) Yes
AUDIT_OPTIONS NUMBER
Yes
REALM_TYPE NUMBER

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#
,      ENABLED
,      AUDIT_OPTIONS
,      REALM_TYPE
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.REALM$;

Dependencies

[top of page]

DVSYS.REALM$ does not reference any database object

DVSYS.REALM$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_REALM
Package BodyDBMS_MACADM - show dependent code
ViewDV$REALM
ViewKU$_DV_REALM_AUTH_VIEW
ViewKU$_DV_REALM_MEMBER_VIEW
ViewKU$_DV_REALM_VIEW