Table structure changes in GoldenGate environments with different table definitions

In this recipe you will learn how to perform table structure changes in a replication environment where the table structures in the source and target environments are not similar.

Getting ready

For this recipe we will refer to the setup done in Setting up a GoldenGate replication between tables with different structures using defgen in Chapter 2, Setting up GoldenGate Replication. For this recipe we are making the following assumptions:

  1. GoldenGate is set up to replicate only DML changes between the source and target environments.
  2. The application will be stopped for making schema changes in the source environment.
  3. The table structures in the source and target databases ...

Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.