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:
|
|
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 |