ALL_SUBSCRIBED_TABLES

ALL_SUBSCRIBED_TABLES describes the 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_TABLES describes all source tables in the database to which any subscriber has subscribed.
USER_SUBSCRIBED_TABLES describes the 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 owner
`SOURCE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Source table name
`VIEW_NAME`	`VARCHAR2(30)`		Subscriber view name
`CHANGE_SET_NAME`	`VARCHAR2(30)`	`NOT NULL`	Change set name
`SUBSCRIPTION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the subscription