Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
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 Go to next page
View PDF

CHANGE_SOURCES

CHANGE_SOURCES enables publishers to view existing change sources. You must have the SELECT_CATALOG_ROLE privilege to access this view.

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

The database identifier of the Oracle host instance (set by CDC when the first log is added to LogMiner)

LOG_DIRECTORY

VARCHAR2(4000)

NOT NULL

File system path on the CDC machine where log files for this source are maintained

LOGFILE_PATTERN

VARCHAR2(30)

This pattern enables you to recognize log files (for example, *.log) if the log location has files in it other than log files

SOURCE_DESCRIPTION

VARCHAR2(255)

Comment field for customers

CREATED

DATE

NOT NULL

Creation date of the change source