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


TABLE: GME.GME_MIGRATION_CONTROL

Object Details
Object Name: GME_MIGRATION_CONTROL
Object Type: TABLE
Owner: GME
FND Design Data: TableGME.GME_MIGRATION_CONTROL
Subobject Name:
Status: VALID


Control Table for Migration to determine whether a table has been migrated


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GME_MIGRATION_CONTROL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTABLE_NAME
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (80) Yes Migrated Table Name
MIGRATED_IND VARCHAR2 (1) Yes Indicator of whether table was migrated, values are Y and N
LAST_UPDATE_DATE DATE
Yes Migration run date
COMMENT1 VARCHAR2 (240)
For future use
COMMENT2 VARCHAR2 (240)
For future use
COMMENT3 VARCHAR2 (240)
For future use
COMMENT4 VARCHAR2 (240)
For future use
COMMENT5 VARCHAR2 (240)
For future use
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLE_NAME
,      MIGRATED_IND
,      LAST_UPDATE_DATE
,      COMMENT1
,      COMMENT2
,      COMMENT3
,      COMMENT4
,      COMMENT5
FROM GME.GME_MIGRATION_CONTROL;

Dependencies

[top of page]

GME.GME_MIGRATION_CONTROL does not reference any database object

GME.GME_MIGRATION_CONTROL is referenced by following:

SchemaAPPS
SynonymGME_MIGRATION_CONTROL