ALL_CHANGE_SOURCES displays information about Change Data Capture change sources.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SOURCE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the change source |
DBID |
NUMBER |
Database identifier | |
LOG_DIRECTORY |
VARCHAR2(2000) |
Log file directory location | |
LOGFILE_PATTERN |
VARCHAR2(30) |
Wildcard pattern for log file names | |
SOURCE_DESCRIPTION |
VARCHAR2(255) |
Description of the change source | |
CREATED |
DATE |
NOT NULL |
Creation date of the change source |
SOURCE_TYPE |
VARCHAR2(18) |
Capture mode of the change source:
|
|
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 the Streams capture process | |
CAPTURE_QUEUE_NAME |
VARCHAR2(30) |
Name of the Streams capture queue name | |
CAPTURE_QUEUE_TABLE_NAME |
VARCHAR2(30) |
Name of the Streams capture table | |
SOURCE_ENABLED |
VARCHAR2(1) |
Indicates whether the change source is enabled (Y) or not (N) |