pdb_setrepddl

Description

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

Syntax

To return replication status of DDL:

pdb_setrepddl

To enable or disable DDL replication:

pdb_setrepddl {enable|disable}

The default setting is disable.

Examples

Example 1

pdb_setrepddl

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

Example 2

pdb_setrepddl enable

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

Example 3

pdb_setrepddl disable

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

Usage

• 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.

See also