[Home] [Help] [Dependency Information]
Object Name: | AD_LONG_COLUMN_CONVERSIONS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | AD.AD_LONG_COLUMN_CONVERSIONS |
Subobject Name: | |
Status: | VALID |
Table to store the registation details of tables and columns to be migrated and table level processing status
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_LONG_COLUMN_CONVERSIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SCHEMA_NAME
TABLE_NAME OLD_COLUMN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEMA_NAME | VARCHAR2 | (30) | Name of the schema in which the table resides | |
TABLE_NAME | VARCHAR2 | (30) | Name of the product table to be migrated. | |
OLD_COLUMN_NAME | VARCHAR2 | (30) | Name of the LONG column to be migrated | |
OLD_DATA_TYPE | VARCHAR2 | (30) | Datatype of the old column (LONG or LONG RAW) | |
NEW_COLUMN_NAME | VARCHAR2 | (30) | New column name to which the data should be migrated | |
NEW_DATA_TYPE | VARCHAR2 | (30) | Data type (CLOB, BLOB or VARCHAR2) of the new column | |
ACTION | VARCHAR2 | (20) | Attribute to show the type of action to be performed on the table (Ex: with_data, without_data, drop_column, no_action) | |
STATUS | VARCHAR2 | (30) | Current status of the migration on the table |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEMA_NAME
, TABLE_NAME
, OLD_COLUMN_NAME
, OLD_DATA_TYPE
, NEW_COLUMN_NAME
, NEW_DATA_TYPE
, ACTION
, STATUS
FROM APPLSYS.AD_LONG_COLUMN_CONVERSIONS;
APPLSYS.AD_LONG_COLUMN_CONVERSIONS does not reference any database object
APPLSYS.AD_LONG_COLUMN_CONVERSIONS is referenced by following:
|
|
|