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

TABLE: APPLSYS.AD_LONG_COLUMN_CONVERSIONS

Object Details
Object Name: AD_LONG_COLUMN_CONVERSIONS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableAD.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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AD_LONG_COLUMN_CONVERSIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHEMA_NAME
ColumnTABLE_NAME
ColumnOLD_COLUMN_NAME
Columns
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
Query Text

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;

Dependencies

[top of page]

APPLSYS.AD_LONG_COLUMN_CONVERSIONS does not reference any database object

APPLSYS.AD_LONG_COLUMN_CONVERSIONS is referenced by following:

SchemaAPPLSYS
ViewAD_LONG_COLUMN_CONVERSIONS#