The DDL support
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 ...
Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.