Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_CHANGE_SOURCES

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

  • HOTLOG

  • SYNCHRONOUS

  • DISTRIBUTED HOTLOG

  • AUTOLOG ONLINE

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)