DBA_SUBSCRIPTIONS

DBA_SUBSCRIPTIONS describes all subscriptions in the database. This view is intended for use by Change Data Capture publishers.

Related View

USER_SUBSCRIPTIONS describes the subscriptions created by the current user.

Column Datatype NULL Description
HANDLE NUMBER NOT NULL Subscription handle
SET_NAME VARCHAR2(30) NOT NULL Change set name
USERNAME VARCHAR2(30) NOT NULL User name of the subscriber
CREATED DATE NOT NULL Subscription creation date
STATUS VARCHAR2(1) NOT NULL Status of the subscriptions:
  • N - Not yet active

  • A - Currently active

EARLIEST_SCN NUMBER NOT NULL Subscription window low boundary
LATEST_SCN NUMBER NOT NULL Subscription window high boundary
DESCRIPTION VARCHAR2(255)   Comment field for the subscriber
LAST_PURGED DATE   Last time the subscriber called the PURGE_WINDOW for this subscription
LAST_EXTENDED DATE   Last time the subscriber called the EXTEND_WINDOW for this subscription
SUBSCRIPTION_NAME VARCHAR2(30) NOT NULL Name of the subscription