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`	User-specified identifier. For synchronous change sources, there is one pre-created source with the `SOURCE_NAME` "`SYNC_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(11)`		Change source capture mode: `AUTOLOG` `HOTLOG` `SYNCHRONOUS`
`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