Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

CHANGE_SOURCES

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