DDL Mapping in Oracle GoldenGate 12.2

DDL Mapping in Oracle GoldenGate 12.2

Recently, I was tasked by a customer to set up DDL replication in GoldenGate 12.2 only for CREATE TABLE, ALTER TABLE, CREATE INDEX and ALTER INDEX operations.  Having used GoldenGate 12.2 for a while I knew that I could do this but I didn’t remember the exact syntax.  Because I was wanting to do a number of statements I needed to make sure that the DDL clause was correct.

My first few tries were not good.  I needed to figure out how to essentially do the following logic:

For mapped statements allow

create AND table
OR
create AND index
OR
alter AND table
OR
alter AND index

The eventual syntax that worked is this:

DDL INCLUDE MAPPED OPTYPE create OBJTYPE ‘table’ &
INCLUDE MAPPED OPTYPE create OBJTYPE ‘index’ &
INCLUDE MAPPED OPTYPE alter OBJTYPE ‘table’ &
INCLUDE MAPPED OPTYPE alter OBJTYPE ‘index’

This took a few tries and I verified that a drop table does not replicate.  Only that statements that I want to allow will replicate.

By |2017-09-20T08:07:20+00:00June 21st, 2016|Performance Wire|Comments Off on DDL Mapping in Oracle GoldenGate 12.2