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 |