ALL_SUBSCRIBED_TABLES

ALL_SUBSCRIBED_TABLES enables subscribers to view all published tables to which they have subscribed.

Related Views

• DBA_SUBSCRIBED_TABLES enables publishers to view all published tables to which they have subscribed.
• USER_SUBSCRIBED_TABLES enables subscribers to view all published tables to which they have subscribed.

  Column	Datatype	Description
  HANDLE	NUMBER	The subscription handle
  SOURCE_SCHEMA_NAME	VARCHAR2(30)	The source table schema identifier
  SOURCE_TABLE_NAME	VARCHAR2(31)	The source table identifier
  VIEW_NAME	VARCHAR2(30)	Holds the generated view name so that change data capture can drop the view when necessary
  CHANGE_SET_NAME	VARCHAR2(30)	The name of the change set to which the change table belongs