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


TABLE: DVSYS.FACTOR_LINK$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: FACTOR_LINK$_PK1
  1. ColumnID#
Unique Key: FACTOR_LINK$_UK1
  1. ColumnPARENT_FACTOR_ID#
  2. ColumnCHILD_FACTOR_ID#
Indexes
Index Type Uniqueness Tablespace Column
FACTOR_LINK$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
FACTOR_LINK$_UK1 NORMAL UNIQUE TablespaceSYSAUX ColumnPARENT_FACTOR_ID#
ColumnCHILD_FACTOR_ID#
FACTOR_LINK$_FK1_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnCHILD_FACTOR_ID#
FACTOR_LINK$_FK_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnPARENT_FACTOR_ID#
Foreign Keys
Table
Foreign Table Foreign Key Column
FACTOR_LINK$ FACTOR_LINK$_FK1 TableFACTOR$ FACTOR_LINK$ CHILD_FACTOR_ID#
FACTOR_LINK$ FACTOR_LINK$_FK TableFACTOR$ FACTOR_LINK$ PARENT_FACTOR_ID#
TableIDENTITY_MAP$ IDENTITY_MAP$_FK1 FACTOR_LINK$ IDENTITY_MAP$ FACTOR_LINK_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
PARENT_FACTOR_ID# NUMBER
Yes
CHILD_FACTOR_ID# NUMBER
Yes
LABEL_IND VARCHAR2 (1) 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#
,      PARENT_FACTOR_ID#
,      CHILD_FACTOR_ID#
,      LABEL_IND
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.FACTOR_LINK$;

Dependencies

[top of page]

DVSYS.FACTOR_LINK$ does not reference any database object

DVSYS.FACTOR_LINK$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_FACTOR_LINK
ViewDBA_DV_IDENTITY_MAP
Package BodyDBMS_MACADM - show dependent code
Package BodyDBMS_MACOLS - show dependent code
ViewDV$FACTOR_LINK
ViewDV$IDENTITY_MAP
PL/SQL PackageFACTOR_LINK$_PRIV - show dependent code
Package BodyFACTOR_LINK$_PRIV - show dependent code
ViewKU$_DV_FACTOR_LINK_VIEW
ViewKU$_DV_IDENTITY_MAP_VIEW