About Oracle GoldenGate Automatic Schema Evolution?

Automatic schema evolution is the capability to detect, manage, and apply changes to a database schema, such as tables, columns, indexes, or relationships, without requiring manual intervention.

Oracle GoldenGate replicates DDL changes from Oracle to Oracle, and MySQL to MySQL. The Automatic Schema Evolution expands DDL replication across a broader set of databases. Automatic schema evolution allows a subset of DDL operations (create or alter table) to be replicated homogeneously and heterogeneously, when traditional DDL replication is unavailable.

Automatic Schema Evolution can be useful in the following scenarios:

• Applying data into the target database using compatible schema and data types

• Automating the target table creation during initial load..

• Creating or altering target tables dynamically to adjust to the source tables that are dynamically created or altered by the application

• Achieving zero downtime when making simple schema changes

The AUTOSCHEMA option needs to be added as a DDL parameter option, with the required inclusion/exclusion criteria, to enable the Automatic Schema functionality. See Enabling Automatic Schema Evolution for details.

AUTOSCHEMAOPTIONS parameter is used to specify related options or overrides when DDL AUTOSCHEMA is enabled. AUTOSCHEMAOPTIONS can be specified as a standalone parameter or as an option in the MAP statement, to confine the corresponding impact only to that MAP statement. See AUTOSCHEMAOPTIONS for details.