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. Prior to Oracle database Version 11.2.0.4, trigger based DDL has to be enabled to perform the DDL replication. Three setup scripts must be run in turn (as SYSDBA) on the source database to install the necessary software components: marker_setup.sql, ddl_setup.sql and role_setup.sql, which can be found in the GoldenGate Home directory. For later database versions, DDL replication is automatically supported without the need for manual installation.

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

The following table lists all the supported DDL commands at the object level:

Operation	Object type...