Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-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 User-specified identifier. For synchronous change sources, there is one pre-created source with the SOURCE_NAME "SYNC_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(11)   Change source capture mode:
  • AUTOLOG

  • HOTLOG

  • SYNCHRONOUS

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