eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_CHANGE_SETS

Object Details

Object Name:	ALL_CHANGE_SETS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Change Data Capture change sets

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SET_NAME	VARCHAR2	(128)	Yes	Name of the change set
CHANGE_SOURCE_NAME	VARCHAR2	(128)	Yes	Change source to which the change set belongs
BEGIN_DATE	DATE			Starting point for capturing change data
END_DATE	DATE			Stopping point for capturing change data
BEGIN_SCN	NUMBER			Not used
END_SCN	NUMBER			Not used
FRESHNESS_DATE	DATE			Not used
FRESHNESS_SCN	NUMBER			Not used
ADVANCE_ENABLED	CHAR	(1)		Not used
IGNORE_DDL	CHAR	(1)		Not used
CREATED	DATE		Yes	Creation date of the change set
ROLLBACK_SEGMENT_NAME	VARCHAR2	(128)		Not used
ADVANCING	CHAR	(1)	Yes	Not used
PURGING	CHAR	(1)	Yes	Not used
LOWEST_SCN	NUMBER			Low water mark for change data in change set
TABLESPACE	VARCHAR2	(30)		Not used
CAPTURE_ENABLED	VARCHAR2	(1)		Whether capture is enabled for change set
STOP_ON_DDL	CHAR	(1)	Yes	Whether change set stops on DDL
CAPTURE_ERROR	CHAR	(1)		Whether there is a capture error
CAPTURE_NAME	VARCHAR2	(128)		Name of Streams capture process
QUEUE_NAME	VARCHAR2	(128)		Name of Streams queue
QUEUE_TABLE_NAME	VARCHAR2	(128)		Name of Streams queue table
APPLY_NAME	VARCHAR2	(128)		Name of the Streams apply process
SET_DESCRIPTION	VARCHAR2	(255)		Description of the change set
PUBLISHER	VARCHAR2	(128)		Publisher of the change set
LOWEST_TIMESTAMP	DATE			Timestamp of record with lowest scn in the change set
MAP_NAME	VARCHAR2	(128)		Name of the mapping table, maps scn to timestamp

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_NAME
,      CHANGE_SOURCE_NAME
,      BEGIN_DATE
,      END_DATE
,      BEGIN_SCN
,      END_SCN
,      FRESHNESS_DATE
,      FRESHNESS_SCN
,      ADVANCE_ENABLED
,      IGNORE_DDL
,      CREATED
,      ROLLBACK_SEGMENT_NAME
,      ADVANCING
,      PURGING
,      LOWEST_SCN
,      TABLESPACE
,      CAPTURE_ENABLED
,      STOP_ON_DDL
,      CAPTURE_ERROR
,      CAPTURE_NAME
,      QUEUE_NAME
,      QUEUE_TABLE_NAME
,      APPLY_NAME
,      SET_DESCRIPTION
,      PUBLISHER
,      LOWEST_TIMESTAMP
,      MAP_NAME
FROM SYS.ALL_CHANGE_SETS;

Dependencies

[top of page]

SYS.ALL_CHANGE_SETS references the following:

SYS: APPLY$_ERROR; CDC_CHANGE_SETS$; STREAMS$_APPLY_PROCESS; STREAMS$_CAPTURE_PROCESS

SYS.ALL_CHANGE_SETS is referenced by following:

PUBLIC: ALL_CHANGE_SETS; CHANGE_SETS