ALL_SUBSCRIPTIONS

ALL_SUBSCRIPTIONS enables subscribers to view all subscriptions. Neither ALL_SUBSCRIPTIONS nor USER_SUBSCRIPTIONS contains the USERNAME column.

Related Views

• DBA_SUBSCRIPTIONS enables publishers to view all subscriptions. You must have the SELECT_CATALOG_ROLE privilege to access this view. DBA_SUBSCRIPTIONS contains the USERNAME column, which lists the user name of the subscriber.
• USER_SUBSCRIPTIONS enables subscribers to view all of their subscriptions.

  Column	Datatype	Description
  HANDLE	NUMBER	The subscription handler
  SET_NAME	VARCHAR2(30)	The change set identifier
  CREATED	DATE	Subscription creation date
  STATUS	VARCHAR2(1)	N indicates not yet active, A indicates is currently active
  EARLIEST_SCN	NUMBER	Starting point for the select/view
  LATEST_SCN	NUMBER	The ending point for the select/view
  DESCRIPTION	VARCHAR2(30)	A comment field for the subscriber
  LAST_PURGED	DATE	The last time the subscriber called the PURGE_WINDOW for this subscription
  LAST_EXTENDED	DATE	The last time the subscriber called the EXTEND_WINDOW for this subscription