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.