Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CHANGE_SETS Change Data Capture change sets

Column ID Column name Data type Length Precision NULL Description
1SET_NAMEVARCHAR230(null)NName of the change set
2CHANGE_SOURCE_NAMEVARCHAR230(null)NChange source to which the change set belongs
3BEGIN_DATEDATE7(null)YStarting point for capturing change data
4END_DATEDATE7(null)YStopping point for capturing change data
5BEGIN_SCNNUMBER22(null)YNot used
6END_SCNNUMBER22(null)YNot used
7FRESHNESS_DATEDATE7(null)YNot used
8FRESHNESS_SCNNUMBER22(null)YNot used
9ADVANCE_ENABLEDVARCHAR21(null)YNot used
10IGNORE_DDLVARCHAR21(null)YNot used
11CREATEDDATE7(null)NCreation date of the change set
12ROLLBACK_SEGMENT_NAMEVARCHAR230(null)YNot used
13ADVANCINGVARCHAR21(null)NNot used
14PURGINGVARCHAR21(null)NNot used
15LOWEST_SCNNUMBER22(null)YLow water mark for change data in change set
16TABLESPACEVARCHAR230(null)YNot used
17CAPTURE_ENABLEDVARCHAR21(null)NWhether capture is enabled for change set
18STOP_ON_DDLVARCHAR21(null)NWhether change set stops on DDL
19CAPTURE_ERRORVARCHAR21(null)NWhether there is a capture error
20CAPTURE_NAMEVARCHAR230(null)YName of Streams capture process
21QUEUE_NAMEVARCHAR230(null)YName of Streams queue
22QUEUE_TABLE_NAMEVARCHAR230(null)YName of Streams queue table
23APPLY_NAMEVARCHAR230(null)YName of the Streams apply process
24SET_DESCRIPTIONVARCHAR2255(null)YDescription of the change set
25PUBLISHERVARCHAR230(null)YPublisher of the change set
26LOWEST_TIMESTAMPDATE7(null)YTimestamp of record with lowest scn in the change set
27MAP_NAMEVARCHAR230(null)YName of the mapping table, maps scn to timestamp

Index | Home | Forums

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