O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

DDL replication

GoldenGate supports the replication of all DDL commands operating at schema level. By default DDL replication is enabled on the target (Replicat) for data integrity and disabled on the source (Extract). Should you wish to perform DDL and DML replication from your source database, the DDL part must be explicitly configured through a single DDL parameter statement.

Tip

GoldenGate does not support DDL only replication. DDL replication must accompany DML replication and is enabled or disabled via the GETTRUNCATES and IGNORETRUNCATES parameters respectively.

The DDL parameter

DDL replication is configured and enabled on the Extract and Replicat process by passing multiple options to the DDL parameter. Not only can DDL operations be filtered ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required