CHANGE_SETS describes existing change sets. The user must have the SELECT_CATALOG_ROLE privilege to access this view. This view is intended for use by Change Data Capture publishers.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SET_NAME |
VARCHAR2(30) |
NOT NULL |
Name of change set |
CHANGE_SOURCE_NAME |
VARCHAR2(30) |
NOT NULL |
Change source to which this change set belongs |
BEGIN_DATE |
DATE |
Starting point for capturing change data | |
END_DATE |
DATE |
Stopping point for capturing change data | |
BEGIN_SCN |
NUMBER |
Reserved for future use | |
END_SCN |
NUMBER |
Reserved for future use | |
FRESHNESS_DATE |
DATE |
Reserved for future use | |
FRESHNESS_SCN |
NUMBER |
Reserved for future use | |
ADVANCE_ENABLED |
VARCHAR2(1) |
Reserved for future use | |
IGNORE_DDL |
VARCHAR2(1) |
Obsolete column | |
CREATED |
DATE |
NOT NULL |
Creation date of the change set |
ROLLBACK_SEGMENT_NAME |
VARCHAR2(30) |
Reserved for future use | |
ADVANCING |
VARCHAR2(1) |
NOT NULL |
Reserved for future use |
PURGING |
VARCHAR2(1) |
NOT NULL |
Indicates whether a purge of old data is in progress for this change set (Y) or not (N) |
LOWEST_SCN |
NUMBER |
Current low-watermark for change data remaining in this set after the latest purge | |
TABLESPACE |
VARCHAR2(30) |
Reserved for future use | |
CAPTURE_ENABLED |
VARCHAR2(1) |
NOT NULL |
Indicates whether capture is enabled (Y) or not (N) |
STOP_ON_DDL |
VARCHAR2(1) |
NOT NULL |
Indicates whether change set stops on DDL (Y) or not (N) |
CAPTURE_ERROR |
VARCHAR2(1) |
NOT NULL |
Indicates whether there is a capture error (Y) or not (N) |
CAPTURE_NAME |
VARCHAR2(30) |
Streams capture process name | |
QUEUE_NAME |
VARCHAR2(30) |
Streams queue name | |
QUEUE_TABLE_NAME |
VARCHAR2(30) |
Streams queue table name | |
APPLY_NAME |
VARCHAR2(30) |
Streams apply process name | |
SET_DESCRIPTION |
VARCHAR2(255) |
Comment field for the publisher | |
PUBLISHER |
VARCHAR2(30) |
Publisher of the change set |