• Arun Kumar

Oracle Golden Gate DDL Replication

Take any one of our previous replication examples and add below in the extract parameter file

DDL INCLUDE MAPPED


Note: Do not use DDL INCLUDE ALL until it is really required.

Now on the source side, try to add a new column to the table and check if the same has been added on target or now.

ALTER TABLE table_name ADD col_namecol_definition;


Setup DDL Replication


Create tables on source proddb

Create table on target with same structure as source

On source, add supplemental logging for the table

Add the extract

Register the extract and edit parameters

Add data pump process

Start the extract and pump process

Let us add replicat on target

Below are the parameters used for rep12

Start replicat process on target

Let us add a column on the source table

Check the extract stats

Check the pump stats

Check the replicat stats

Now check the target table if the new column is added or not



Recent Posts

See All

Install Oracle 12c Golden Gate on Oracle Linux

In this article we will look at the steps to install oracle 12c Golden Gate on Oracle Enterprise Linux 6.5. The steps involved are: Virtual Machine Setup Install Oracle 12c Database Install Oracle 12c

Single Table Replication – Same Schema

In this article we will be looking at single table replication using Oracle Golden Gate where the schema name is same on both source and target database. Create Sample Table Create Fox user on both pr

Single Table Replication – Different Schema

In this article we will be looking at single table replication using Oracle Golden Gate where the schema name is different on source and target but table structure remains same. Create Sample Table Cr

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis