[Home] [Help] [Dependency Information]
Object Name: | FND_TS_MIG_CMDS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_TS_MIG_CMDS |
Subobject Name: | |
Status: | VALID |
This table contains the commands generated for migrating Objects from old tablesapce to new tablespace
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_TS_MIG_CMDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LINENO |
FND_TS_MIG_CMDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARENT_OWNER
PARENT_OBJECT_NAME |
FND_TS_MIG_CMDS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OWNER
OBJECT_TYPE OBJECT_NAME LINENO |
FND_TS_MIG_CMDS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARENT_LINENO
MIGRATION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINENO | NUMBER | Yes | Unique sequance | |
SUBOBJECT_TYPE | VARCHAR2 | (30) | This column will contain the sub object of the main object | |
START_DATE | DATE | Migration Start date | ||
OWNER | VARCHAR2 | (30) | Yes | schema name of the database object to be migrated |
OBJECT_TYPE | VARCHAR2 | (30) | Type of the database object to be migrated(TABLE, INDEX, or CLUSTER) | |
OBJECT_NAME | VARCHAR2 | (80) | Name of the object name to be migrated | |
OLD_TABLESPACE | VARCHAR2 | (30) | Name of the tablespace from where table was moved | |
NEW_TABLESPACE | VARCHAR2 | (30) | Name of the new tablespace where object will resides | |
MIGRATION_CMD | VARCHAR2 | (4000) | Text of the migration command | |
MIGRATION_STATUS | VARCHAR2 | (30) | Status of migraion (GENERATED, SUCCESS or ERROR) | |
ERROR_TEXT | VARCHAR2 | (4000) | Oracle Error in case of migration error | |
LAST_UPDATE_DATE | DATE | Last update date | ||
GENERATION_DATE | DATE | Date/Time on which the migration command was generated | ||
END_DATE | DATE | Date/Time of the completion of migration command execution | ||
TOTAL_BLOCKS | NUMBER | (15) | Size of the object in blocks | |
INDEX_PARALLEL | VARCHAR2 | (10) | Index move command having Parallel/No Parallel Clause | |
PARENT_OBJECT_NAME | VARCHAR2 | (30) | Name of the parent object name for the child objects | |
PARENT_LINENO | NUMBER | Line no of the parent object | ||
EXECUTION_MODE | VARCHAR2 | (1) | Execution Mode for the commands (s/p) | |
PARTITIONED | VARCHAR2 | (3) | Object partition (Yes/No) | |
PARENT_OWNER | VARCHAR2 | (30) | Parent owner name for child objects |
Cut, paste (and edit) the following text to query this object:
SELECT LINENO
, SUBOBJECT_TYPE
, START_DATE
, OWNER
, OBJECT_TYPE
, OBJECT_NAME
, OLD_TABLESPACE
, NEW_TABLESPACE
, MIGRATION_CMD
, MIGRATION_STATUS
, ERROR_TEXT
, LAST_UPDATE_DATE
, GENERATION_DATE
, END_DATE
, TOTAL_BLOCKS
, INDEX_PARALLEL
, PARENT_OBJECT_NAME
, PARENT_LINENO
, EXECUTION_MODE
, PARTITIONED
, PARENT_OWNER
FROM APPLSYS.FND_TS_MIG_CMDS;
APPLSYS.FND_TS_MIG_CMDS does not reference any database object
APPLSYS.FND_TS_MIG_CMDS is referenced by following:
|
|
|