To replicate DDL, use pdb_setrepddl to set filtering rules accordingly.
You
must set the ddl_username and the ddl_password if the Replication Server parameter
dsi_replication_ddl is off.
To replicate DDL:
-
Replication Agent requires a unique user name to be supplied
that has authority to execute all DDL commands at the standby database.
-
Replication Server must have a database-level replication
definition with replicate DDL set in the
definition.
See:
- pdb_setrepddl, ddl_username, and
ddl_password in the Replication Agent Reference
Manual.
- SAP Replication Server Reference Manual > SAP Replication Server Commands
> alter connection > dsi_replication_ddl.