Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

CHANGE_SETS

CHANGE_SETS describes existing change sets. The user must have the SELECT_CATALOG_ROLE privilege to access this view. This view is intended for use by Change Data Capture publishers.

Column Datatype NULL Description
SET_NAME VARCHAR2(30) NOT NULL Name of change set
CHANGE_SOURCE_NAME VARCHAR2(30) NOT NULL Change source to which this change 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)   Reserved for future use
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 (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