Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_SUBSCRIBED_COLUMNS
describes the columns of source tables to which any subscription accessible to the current user has subscribed. This view is intended for use by Change Data Capture subscribers.
Related Views
DBA_SUBSCRIBED_COLUMNS
describes the columns of source tables to which any subscriber has subscribed.
USER_SUBSCRIBED_COLUMNS
describes the columns of source tables to which the current user has subscribed.
Column | Datatype | NULL | Description |
---|---|---|---|
HANDLE |
NUMBER |
NOT NULL |
Subscription handle |
SOURCE_SCHEMA_NAME |
VARCHAR2(30) |
NOT NULL |
Source table schema identifier |
SOURCE_TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Source table identifier |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Source table column identifier |
SUBSCRIPTION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the subscription |