Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CHANGE_SOURCES Change Data Capture change sources

Column ID Column name Data type Length Precision NULL Description
1SOURCE_NAMEVARCHAR230(null)NName of the change source
2DBIDNUMBER22(null)YDatabase identifier
3LOG_DIRECTORYVARCHAR22000(null)YLog file directory location
4LOGFILE_PATTERNVARCHAR230(null)YFile name wildcard pattern for log files
5SOURCE_DESCRIPTIONVARCHAR2255(null)YDescription of the change source
6CREATEDDATE7(null)NCreation date of the change source
7SOURCE_TYPEVARCHAR218(null)YCapture mode of the change source
8SOURCE_DATABASEVARCHAR2128(null)YGlobal name of source database
9FIRST_SCNNUMBER22(null)YSCN of a LogMiner dictionary at which capture can begin
10PUBLISHERVARCHAR230(null)YPublisher of the change source
11CAPTURE_NAMEVARCHAR230(null)YName of the Streams capture
12CAPTURE_QUEUE_NAMEVARCHAR230(null)YName of the Streams capture queue name
13CAPTURE_QUEUE_TABLE_NAMEVARCHAR230(null)YName of the Streams capture table name
14SOURCE_ENABLEDVARCHAR21(null)YWhether change source is enabled ?

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:22
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here