HANDLE |
NUMBER |
NOT NULL |
Subscription handler |
SET_NAME |
VARCHAR2(30) |
NOT NULL |
Change set identifier |
USERNAME |
VARCHAR2(30) |
NOT NULL |
User name of the subscriber |
CREATED |
DATE |
NOT NULL |
Subscription creation date |
STATUS |
VARCHAR2(1) |
NOT NULL |
N indicates not yet active, A indicates is currently active |
EARLIEST_SCN |
NUMBER |
NOT NULL |
Starting point for the select/view |
LATEST_SCN |
NUMBER |
NOT NULL |
Ending point for the select/view |
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 |
