CHANGE_SOURCES

CHANGE_SOURCES describes existing change sources. 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
`SOURCE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of change source
`DBID`	`NUMBER`		Reserved for future use
`LOG_DIRECTORY`	`VARCHAR2(2000)`		Reserved for future use
`LOGFILE_PATTERN`	`VARCHAR2(30)`		Reserved for future use
`SOURCE_DESCRIPTION`	`VARCHAR2(255)`		Comment field for customers
`CREATED`	`DATE`	`NOT NULL`	Creation date of the change source
`SOURCE_TYPE`	`VARCHAR2(18)`		Change source capture mode: `AUTOLOG` `HOTLOG` `SYNCHRONOUS` `DISTRIBUTED HOTLOG` `AUTOLOG ONLINE`
`SOURCE_DATABASE`	`VARCHAR2(128)`		Global name of the source database
`FIRST_SCN`	`NUMBER`		SCN of a LogMiner dictionary at which capture can begin
`PUBLISHER`	`VARCHAR2(30)`		Publisher of the change source
`CAPTURE_NAME`	`VARCHAR2(30)`		Name of Streams capture process
`CAPTURE_QUEUE_NAME`	`VARCHAR2(30)`		Name of Streams capture queue
`CAPTURE_QUEUE_TABLE_NAME`	`VARCHAR2(30)`		Name of Streams capture queue table
`SOURCE_ENABLED`	`VARCHAR2(1)`		Whether or not source is enabled