| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
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) |
See Also:
"USER_PUBLISHED_COLUMNS"
