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)?