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.