../E40402-16.epub /> ../E40402-16.mobi />

DBA_SUBSCRIBED_COLUMNS

DBA_SUBSCRIBED_COLUMNS describes the columns of source tables to which any subscriber has subscribed. This view is intended for use by Change Data Capture publishers.

Related View

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
SOURCE_DB VARCHAR2(128)   Source database global name