[Home] [Help] [Dependency Information]
Object Name: | ALL_CHANGE_SOURCES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Change Data Capture change sources
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_NAME | VARCHAR2 | (128) | Yes | Name of the change source |
DBID | NUMBER | Database identifier | ||
LOG_DIRECTORY | VARCHAR2 | (2000) | Log file directory location | |
LOGFILE_PATTERN | VARCHAR2 | (128) | File name wildcard pattern for log files | |
SOURCE_DESCRIPTION | VARCHAR2 | (255) | Description of the change source | |
CREATED | DATE | Yes | Creation date of the change source | |
SOURCE_TYPE | VARCHAR2 | (18) | Capture mode of the change source | |
SOURCE_DATABASE | VARCHAR2 | (128) | Global name of source database | |
FIRST_SCN | NUMBER | SCN of a LogMiner dictionary at which capture can begin | ||
PUBLISHER | VARCHAR2 | (128) | Publisher of the change source | |
CAPTURE_NAME | VARCHAR2 | (128) | Name of the Streams capture | |
CAPTURE_QUEUE_NAME | VARCHAR2 | (128) | Name of the Streams capture queue name | |
CAPTURE_QUEUE_TABLE_NAME | VARCHAR2 | (128) | Name of the Streams capture table name | |
SOURCE_ENABLED | CHAR | (1) | Whether change source is enabled ? |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_NAME
, DBID
, LOG_DIRECTORY
, LOGFILE_PATTERN
, SOURCE_DESCRIPTION
, CREATED
, SOURCE_TYPE
, SOURCE_DATABASE
, FIRST_SCN
, PUBLISHER
, CAPTURE_NAME
, CAPTURE_QUEUE_NAME
, CAPTURE_QUEUE_TABLE_NAME
, SOURCE_ENABLED
FROM SYS.ALL_CHANGE_SOURCES;
|
|
|