|
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
|
