IBM Support

How do I start replication after Oracle DDL changes?

How To


Summary

This document describes the steps to follow to resume replication following a DDL change that results in a table structure change.

CDC maintains and depends on metadata describing source and target tables and columns being replicated. When DDL changes occur which results in the table representation in the log to differ versus the image currently in the CDC metadata (usually due to a change to the source table structures), the metadata no longer contains the correct information with which to read source database log records to capture change data during mirroring.

For that reason, following a DDL change that results in table structural changes, some action is required to update the metadata before replication can be performed or resumed. This document describes how to update table definitions to accommodate a DDL change so that replication can proceed.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"ARM Category":[{"code":"a8m50000000L3GOAA0","label":"CDC-\u003EEngine Issues-\u003ESource Engine Issues-\u003EDDL Related"}],"ARM Case Number":"TS003405122","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
14 May 2020

UID

ibm16209511