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 ...