DDL Notification on Target Tables

Oracle GoldenGate Replicat caches target table metadata during DML replication. Out of band DDL changes makes cached metadata obsolete. For example, when an application patch is applied to the target database before upgrading the source.

Starting with Oracle GoldenGate 23ai, Replicat uses efficient table DDL change notification to automatically detect target table metadata changes. Oracle GoldenGate registers for DDL notification on a table when the metadata is cached. Whenever DDL is performed on the target table, Replicat is notified and it invalidates any cached metadata. Replicat reloads the target table metadata, next time it applies DML to the target table. This feature is applicable to all types of Replicat for the Oracle Database. See TARGETDDLNOTIFY in the Parameters and Functions Reference for Oracle GoldenGate to learn about the parameter options and syntax.

For details about Efficient Table Change DDL Notification, see Using Efficient Table DDL Change Notification.