[Home] [Help] [Dependency Information]
Object Name: | IGW_DUPLICATIONS_T |
---|---|
Object Type: | TABLE |
Owner: | IGW |
Subobject Name: | |
Status: | VALID |
IGW_DUPLICATIONS_T is used to store a map between old and new ids which are needed for duplication of rows in tables in which surrogate keys are used to define parent child relationships. The data in this table is temporary and is deleted after use.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUPLICATION_ID | NUMBER | (15) | Duplication Instance Identifier | |
TABLE_NAME | VARCHAR2 | (36) | Name of table to be duplicated | |
OLD_ID | NUMBER | (15) | Old Id | |
NEW_ID | NUMBER | (15) | New Id |
Cut, paste (and edit) the following text to query this object:
SELECT DUPLICATION_ID
, TABLE_NAME
, OLD_ID
, NEW_ID
FROM IGW.IGW_DUPLICATIONS_T;
IGW.IGW_DUPLICATIONS_T does not reference any database object
IGW.IGW_DUPLICATIONS_T is referenced by following:
|
|
|