Enabling and Disabling DDL Replication

Before you enable DDL replication, you must set the ddl_username and ddl_password configuration parameters to the user name that Replication Server uses at the replicate database when executing the DDL commands. This user name must be different from the maintenance user that was configured in the Replication Server replicate connection.

For details, see the Replication Agent Reference Manual.

Note: DDL replication is available only for Oracle and Microsoft SQL Server. See the Replication Agent Primary Database Guide for more information on the DDL commands that are not replicated.

To temporarily suspend replication of DDL, use the pdb_setrepddl command to disable replication of DDL. To resume replication of DDL, use the pdb_setrepddl command to enable replication. See the Replication Agent Reference Manual for details on using the pdb_setrepddl command.

Note: To 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.