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.

You do not need to set the ddl_username and ddl_password parameters if the Replication Server parameter dsi_replication_ddl is on.

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.