CDC Publishing Changes For Not Interested Columns Into The Change Table
Last updated on MARCH 02, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 126.96.36.199 - 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".
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms