GoldenGate supports the replication of DDL commands operating at the schema level. By default, the DDL replication is enabled on the target (Replicat) for data integrity and disabled on the source (Extract). If 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.
The support for DDL has increased since the integrated capture feature was introduced in Oracle 11g Release 2. If you wish to perform extensive DDL replication, particularly in the active-active configuration, refer to the following online Oracle documentation to assess the data type and database object support:
https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/system_requirements.htm#GIORA121
The DDL replication for database tables is supported in Teradata database environments for unidirectional and bidirectional configurations between two systems. The source and target database must be identical.
