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

TABLE: DVSYS.IDENTITY$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: IDENTITY$_PK1
  1. ColumnID#
Unique Key: IDENTITY$_UK1
  1. ColumnFACTOR_ID#
  2. ColumnVALUE
Indexes
Index Type Uniqueness Tablespace Column
IDENTITY$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
IDENTITY$_UK1 NORMAL UNIQUE TablespaceSYSAUX ColumnFACTOR_ID#
ColumnVALUE
IDENTITY$_FK_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnFACTOR_ID#
Foreign Keys
Table
Foreign Table Foreign Key Column
IDENTITY$ IDENTITY$_FK TableFACTOR$ IDENTITY$ FACTOR_ID#
TableIDENTITY_MAP$ IDENTITY_MAP$_FK IDENTITY$ IDENTITY_MAP$ IDENTITY_ID#
TablePOLICY_LABEL$ IDENTITY_LABEL$_FK IDENTITY$ POLICY_LABEL$ IDENTITY_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
FACTOR_ID# NUMBER
Yes
VALUE VARCHAR2 (1024) Yes
TRUST_LEVEL 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#
,      FACTOR_ID#
,      VALUE
,      TRUST_LEVEL
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.IDENTITY$;

Dependencies

[top of page]

DVSYS.IDENTITY$ does not reference any database object

DVSYS.IDENTITY$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_IDENTITY
ViewDBA_DV_IDENTITY_MAP
ViewDBA_DV_POLICY_LABEL
Package BodyDBMS_MACADM - show dependent code
Package BodyDBMS_MACOLS - show dependent code
Package BodyDBMS_MACSEC - show dependent code
ViewDV$IDENTITY
ViewDV$IDENTITY_MAP
ViewDV$POLICY_LABEL
PL/SQL PackageIDENTITY$_PRIV - show dependent code
Package BodyIDENTITY$_PRIV - show dependent code
ViewKU$_DV_IDENTITY_MAP_VIEW
ViewKU$_DV_IDENTITY_VIEW