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