DBA_PUBLISHED_COLUMNS

DBA_PUBLISHED_COLUMNS describes all source table columns in the database which have been published for the source tables. This view is intended for use by Change Data Capture publishers.

Related View

USER_PUBLISHED_COLUMNS describes the source table columns owned by the current user which have been published for the source tables. This view does not display the CHANGE_TABLE_SCHEMA or CHANGE_TABLE_NAME columns.

Column	Datatype	NULL	Description
`CHANGE_SET_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the change set
`CHANGE_TABLE_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Associated change table owner
`CHANGE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Associated change table name
`PUB_ID`	`NUMBER`	`NOT NULL`	Publication identifier
`SOURCE_SCHEMA_NAME`	`VARCHAR2(30)`	`NOT NULL`	Table owner in the source database
`SOURCE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Table name in the source database
`COLUMN_NAME`	`VARCHAR2(30)`	`NOT NULL`	Column name
`DATA_TYPE`	`VARCHAR2(106)`		Column datatype
`DATA_LENGTH`	`NUMBER`	`NOT NULL`	Column length (in bytes)
`DATA_PRECISION`	`NUMBER`		Decimal precision for `NUMBER` datatypes; binary precision for `FLOAT` datatypes; NULL for all other datatypes
`DATA_SCALE`	`NUMBER`		Digits to the right of a decimal point in a number
`NULLABLE`	`VARCHAR2(1)`		Indicates whether NULLs are allowed (`Y`) or not (`N`)