Introduction

Replication technologies are mostly used to synchronize the data changes between two or more environments. However, there are a few environments where applications modify the structures of the objects along with the data. In such cases, the job of replication technologies extends from just copying DMLs to replicating these structural changes as well. Oracle GoldenGate supports replication of DDL and DML changes between environments.

Before starting the replication between two environments, it is quite important to have a consistent point. The process of creating a synchronous state in a target environment is called an initial load or instantiation. GoldenGate offers many methods to perform an initial load.

In this chapter, we will look into the setup required, and the methods for performing a DDL replication and initial load using GoldenGate.