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


TABLE: DVSYS.CODE$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CODE$_PK1
  1. ColumnID#
Unique Key: CODE$_UK1
  1. ColumnCODE_GROUP
  2. ColumnCODE
Indexes
Index Type Uniqueness Tablespace Column
CODE$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
CODE$_UK1 NORMAL UNIQUE TablespaceSYSAUX ColumnCODE_GROUP
ColumnCODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableCOMMAND_RULE$ COMMAND_RULE$_FK1 CODE$ COMMAND_RULE$ CODE_ID#
TableIDENTITY_MAP$ IDENTITY_MAP$_FK2 CODE$ IDENTITY_MAP$ OPERATION_CODE_ID#
TableMAC_POLICY$ MAC_POLICY$_FK1 CODE$ MAC_POLICY$ ALGORITHM_CODE_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
CODE_GROUP VARCHAR2 (128) Yes
CODE VARCHAR2 (128) 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#
,      CODE_GROUP
,      CODE
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.CODE$;

Dependencies

[top of page]

DVSYS.CODE$ does not reference any database object

DVSYS.CODE$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_CODE
Package BodyDBMS_MACOLS - show dependent code
Package BodyDBMS_MACOLS_SESSION - show dependent code
Package BodyDBMS_MACUTL - show dependent code
ViewDV$CODE
ViewKU$_DV_IDENTITY_MAP_VIEW