Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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