DBA_PUBLISHED_COLUMNS

DBA_PUBLISHED_COLUMNS describes all existing source column tables. You must have the SELECT_CATALOG_ROLE privilege to access this view.

Column	Datatype	Description
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)?