|
SET_NAME |
VARCHAR2(30) |
NOT NULL |
User specified identifier. For synchronous change sources, there is one pre-created source with the SET_NAME "SYNC_SET." |
|
CHANGE_SOURCE_NAME |
VARCHAR2(30) |
NOT NULL |
The change source to which this set belongs |
|
BEGIN_DATE |
DATE |
|
The starting point for capturing change data |
|
END_DATE |
DATE |
|
The stopping point for capturing change data |
|
BEGIN_SCN |
NUMBER |
|
The starting point for capturing change data |
|
END_SCN |
NUMBER |
|
The stopping point for capturing change data |
|
FRESHNESS_DATE |
DATE |
|
The stopping point for the last successful advance |
|
FRESHNESS_SCN |
NUMBER |
|
The stopping point for the last successful advance |
|
ADVANCE_ENABLED |
VARCHAR2(1) |
NOT NULL |
Identifies eligibility for advance (Y|N) |
|
IGNORE_DDL |
VARCHAR2(1) |
NOT NULL |
Identifies whether to continue (Y) or stop (N) |
|
CREATED |
DATE |
NOT NULL |
The creation date of the change set |
|
ROLLBACK_SEGMENT_NAME |
VARCHAR2(30) |
|
Used during advance (optional) |
|
ADVANCING |
VARCHAR2(1) |
NOT NULL |
Identifies whether or not (Y|N) an advance is in progress for this set (set by advance) |
|
PURGING |
VARCHAR2(1) |
NOT NULL |
Identifies whether or not (Y|N) a purge of old data is in progress for this change set (set by advance) |
|
LOWEST_SCN |
NUMBER |
NOT NULL |
Current low water mark for change data remaining in this set after the latest purge |
|
TABLESPACE |
VARCHAR2(30) |
NOT NULL |
Location where advance creates LCR staging tables |
