Oracle GoldenGate – DDL Data Definition Language Replication

DDL – Data Definition Language Replication

By default, DDL (Data Definition Language) replication is disabled on the source database (Extract side) but is enabled on the target Database (Replicat side).

To enable and manage DDL replication, use the DDL parameter specified in the Extract parameter file.
DDL can be used in conjunction with filter options.
DDL Include All: It will transmit all DDL operations to the Replicat.
DDL Include All, Exclude ObjName schemaname.* : It will exclude from replication all objects created in the schema.
Only one DDL parameter can be used in a parameter file. You can, however, combine multiple inclusion and exclusion options to filter the DDL to the required level. When combined, multiple filter option specifications are linked logically as AND statements.

The ‘All’ keyword in ‘DDL Include ALL’ refers to the scope of the DDL and means ‘Mapped’, ‘Unmapped’ and ‘Other’.

Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Notify of
Inline Feedbacks
View all comments