CHANGE_SET_NAME |
VARCHAR2(30) |
Name of the change set |
CHANGE_TABLE_SCHEMA |
VARCHAR2(30) |
Associated change table owner |
CHANGE_TABLE_NAME |
VARCHAR2(31) |
Associated change table name |
PUB_ID |
NUMBER |
Publication identifier (change table object number) |
SOURCE_SCHEMA_NAME |
VARCHAR2(30) |
Table owner in the source system |
SOURCE_TABLE_NAME |
VARCHAR2(31) |
Table name in the source system |
COLUMN_NAME |
VARCHAR2(30) |
Column name |
DATA_TYPE |
VARCHAR2(30) |
Column datatype |
DATA_LENGTH |
NUMBER |
Column length in bytes |
DATA_PRECISION |
NUMBER |
Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes |
DATA_SCALE |
NUMBER |
Digits to the right of a decimal point in a number |
NULLABLE |
CHAR(1) |
Nulls allowed (Y |N )? |