SET_NAME |
VARCHAR2(30) |
NOT NULL |
User-specified identifier. For synchronous change sets, there is one pre-created set with the SET_NAME "SYNC_SET". |
CHANGE_SOURCE_NAME |
VARCHAR2(30) |
NOT NULL |
Change source to which this 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) |
|
Indicates whether eligibility for advance (Y) or not (N) |
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 (set by advance) (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 |
