My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - 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

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