TARGETDDLNOTIFY | NOTARGETDDLNOTIFY

Valid For

Replicat

Description

This parameter controls whether or not Replicat uses DDL notification to synchronize its target table metadata cache. If it's not supported by the database, then the parameter is ignored. It is supported by all types of Replicat (classic, coordinated, integrated, parallel and parallel integrated). It applies to all tables mapped by the Replicat.

It is ON by default if the target Oracle database supports it.

NOTARGETDDLNOTIFY turns it OFF.

Default

ON

Syntax

TARGETDDLNOTIFY

Examples

For Oracle database 23ai and Oracle GoldenGate 23ai Replicat, the target table DDL notification is enabled by default. The following example shows how to turn off target table DDL notification for Replicat in the Replicat parameter file:

NOTARGETDDLNOTIFY