My Oracle Support Banner

CDC Publishing Changes For Not Interested Columns Into The Change Table (Doc ID 1300395.1)

Last updated on MARCH 02, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.2 to 11.1
Information in this document applies to any platform.


This is a CDC Asynchronous Hotlog configuration, where there is one source table, let's say with 3 columns, COL1, COL2 and COL3.

The change table is created on interest of COL1 and COL2 only, and the subscription is also based on these two first columns.

Any update on source table for COL3 generates 2 new rows at change table, and upon the extend window call (DBMS_CDC_SUBSCRIBE.EXTEND_WINDOW), these two rows are made available to the subscriber too. These two rows have OPERATION$ values for "UO" and "UN".


Implemented CDC Asynchronous Hotlog configuration.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.