pdb_setrepddl

This command is available only for Oracle and Microsoft SQL Server.

Returns DDL replication status; enables or disables replication for DDL statements.

To return replication status of DDL:

pdb_setrepddl

To enable or disable DDL replication:

pdb_setrepddl {enable|disable}

The default setting is disable.

pdb_setrepddl

This command returns the current DDL replication status for the primary database.

pdb_setrepddl enable

This command enables replication of DDL commands issued into the primary database after this point in time.

pdb_setrepddl disable

This command disables replication of DDL commands issued into the primary database after this point in time.

This is the flag that turns DDL replication on or off. By default, it is set to off (disable).
In addition to enabling DDL replication using pdb_setrepddl command, you must set the Replication Agent ddl_username and ddl_password parameters.
If the Replication Agent has not been initialized, the pdb_setrepddl command returns an error.
The pdb_setrepddl command with enable/disable option is valid only when the instance is in Admin state.
The pdb_setrepddl command with no option is valid when the instance is in Admin or Replicating state.

Some DDL commands are filtered even when DDL replication is enabled. See the Replication Agent Primary Database Guide for more information.