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.
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) |
No comments:
Post a Comment