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

Starting point for capturing change data

END_DATE

DATE

Stopping point for capturing change data

BEGIN_SCN

NUMBER

Starting point for capturing change data

END_SCN

NUMBER

Stopping point for capturing change data

FRESHNESS_DATE

DATE

Stopping point for the last successful advance

FRESHNESS_SCN

NUMBER

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