Enabling and disabling replication for DDL

NoteDDL replication is available only for Oracle. See the Replication Agent Primary Database Guide for more information on the DDL commands that that are not replicated.

If you need to temporarily suspend replication of DDL, you can use the pdb_setrepddl command to disable replication of DDL. When you are ready to resume replication of DDL, you can use the pdb_setrepddl command to enable replication.

When you set the value of pdb_setrepddl to enable, all DDL in your primary database is replicated.

NoteTo replicate DDL, Replication Server must have a database-level replication definition with replicate DDL set in the definition. For details on creating a database-level replication definition, see the Replication Agent Reference Manual.