CHANGE_SOURCES

CHANGE_SOURCES enables publishers to view existing change sources. You must have the SELECT_CATALOG_ROLE privilege to access this view.

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		The database identifier of the Oracle host instance (set by CDC when the first log is added to LogMiner)
LOG_DIRECTORY	VARCHAR2(4000)	NOT NULL	The file system path on the CDC machine where log files for this source are maintained
LOGFILE_PATTERN	VARCHAR2(30)		This pattern enables you to recognize log files (for example, *.log) if the log location has files in it other than log files
SOURCE_DESCRIPTION	VARCHAR2(255)		Comment field for customers
CREATED	DATE	NOT NULL	The creation date of the change source