DBA_SUBSCRIPTIONS describes all subscriptions in the database. This view is intended for use by Change Data Capture publishers.
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:
|
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 |
See Also:
"USER_SUBSCRIPTIONS"