DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_CHANGE_SOURCES

Object Details
Object Name: ALL_CHANGE_SOURCES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Change Data Capture change sources

[View Source]

Columns
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 ?
Query Text

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;

Dependencies

[top of page]

SYS.ALL_CHANGE_SOURCES references the following:

SchemaSYS
TableCDC_CHANGE_SOURCES$
SYS.ALL_CHANGE_SOURCES is referenced by following:

SchemaPUBLIC
SynonymALL_CHANGE_SOURCES
SynonymCHANGE_SOURCES