Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CHANGE_TABLES Change Data Capture change tables

Column ID Column name Data type Length Precision NULL Description
1CHANGE_TABLE_SCHEMAVARCHAR230(null)NOwner of the change table
2CHANGE_TABLE_NAMEVARCHAR230(null)NName of the change table
3CHANGE_SET_NAMEVARCHAR230(null)NChange set to which change table belongs
4SOURCE_SCHEMA_NAMEVARCHAR230(null)NOwner of the source table for the change table
5SOURCE_TABLE_NAMEVARCHAR230(null)NName of the source table for the change table
6CREATEDDATE7(null)NCreation date of the change table
7CREATED_SCNNUMBER22(null)YCreation SCN of the change table
8CAPTURED_VALUESVARCHAR21(null)NIndicates whether OLD, NEW or BOTH update values are captured
9PUB_IDNUMBER22(null)NPublication ID displayed to subscribers for the change table

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