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 support

GoldenGate allows DDL replication for Oracle databases, which is important when structural changes are made to your source tables. You would not want your Replicat process to abend because it can no longer insert a record into the respective target table. Before we can perform DDL replication, two setup scripts must be run in turn, as SYSDBA on the source database to install the necessary software components; setup.sql and then ddl_setup.sql both of which can be found in the GoldenGate Home directory.

GoldenGate will replicate the majority of ALTER TABLE commands including TRUNCATE. Commands that operate at database level, such as ALTER DATABASE and ALTER SYSTEM are not supported.

The following table lists all supported DDL commands ...

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