Enabling and disabling replication for DDL

NoteFor more information on the DDL commands that are not replicated, see Appendix C, “Mirror Replication Agent and Oracle Databases.”

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.

NoteDDL replication is enabled, by default.

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 Mirror Replication Agent Reference Manual.