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

TABLE: DVSYS.IDENTITY_MAP$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: IDENTITY_MAP$_PK1
  1. ColumnID#
Indexes
Index Type Uniqueness Tablespace Column
IDENTITY_MAP$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
IDENTITY_MAP$_FK1_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnFACTOR_LINK_ID#
IDENTITY_MAP$_FK2_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnOPERATION_CODE_ID#
IDENTITY_MAP$_FK_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnIDENTITY_ID#
IDENTITY_MAP$_UK_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnIDENTITY_ID#
ColumnFACTOR_LINK_ID#
ColumnOPERATION_CODE_ID#
Foreign Keys
Table
Foreign Table Foreign Key Column
IDENTITY_MAP$ IDENTITY_MAP$_FK2 TableCODE$ IDENTITY_MAP$ OPERATION_CODE_ID#
IDENTITY_MAP$ IDENTITY_MAP$_FK1 TableFACTOR_LINK$ IDENTITY_MAP$ FACTOR_LINK_ID#
IDENTITY_MAP$ IDENTITY_MAP$_FK TableIDENTITY$ IDENTITY_MAP$ IDENTITY_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
IDENTITY_ID# NUMBER
Yes
FACTOR_LINK_ID# NUMBER

OPERATION_CODE_ID# NUMBER
Yes
OPERAND1 VARCHAR2 (1024)
OPERAND2 VARCHAR2 (1024)
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#
,      IDENTITY_ID#
,      FACTOR_LINK_ID#
,      OPERATION_CODE_ID#
,      OPERAND1
,      OPERAND2
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.IDENTITY_MAP$;

Dependencies

[top of page]

DVSYS.IDENTITY_MAP$ does not reference any database object

DVSYS.IDENTITY_MAP$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_IDENTITY_MAP
Package BodyDBMS_MACADM - show dependent code
ViewDV$IDENTITY_MAP
PL/SQL PackageIDENTITY_MAP$_PRIV - show dependent code
Package BodyIDENTITY_MAP$_PRIV - show dependent code
ViewKU$_DV_IDENTITY_MAP_VIEW