Replicate changes that only affect large objects - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

When Connect CDC attempts to capture and replicate a change that only affects a large object (LOB) in any row, the results may vary depending on the source database Oracle version, including minor or fix releases. In all cases, Connect CDC captures and replicates the key column(s) and LOB after values. However, limited version testing reveals the following general LOB replication behavior for major Oracle releases:

  • Oracle 19c: Connect CDC captures and replicates the values (after/unchanged) of all other non-LOB columns

  • Oracle 18c and 11g: Connect CDC does not capture the values of all other non-LOB columns. Altering the database to add supplemental logging to all columns enables Connect CDC to capture and replicate non-LOB columns

  • Oracle 12c: Connect CDC does not capture the values of all other non-LOB columns. The only workaround found in testing requires you to change a non-LOB column whenever any LOB column changes. For example, changing a timestamp column or assigning the current value to a non-LOB column whenever a LOB column changes enables Connect CDC to capture and replicate non-LOB columns when a LOB column changes.