Using Automatic Schema Evolution

Oracle GoldenGate supports two mechanisms to keep the target objects in sync with the schema changes on the source objects, that are part of the data replication:

DDL Replication is supported for Oracle to Oracle, and MySQL to MySQL only. It can be enabled either on all objects in the Replicat run, or can be confined to selected object names or types using the using the DDL INCLUDE/EXCLUDE statements along with OBJTYPE/OBJNAME options. Similar support has been provided for the AUTOSCHEMA functionality.

Automatic Schema Evolution functionality supports multiple databases in both homogeneous and heterogeneous topologies. It provides a default datatype mapping for every supported source and target database replication. It also allows you to override certain attributes while creating or altering the tables on the target database.