To replicate DDL in Oracle, in addition to setting the value of pdb_setrepddl to enable, you must set the Replication Agent ddl_username and ddl_password parameters. The ddl_username parameter is the database user name included in LTL for replicating DDL commands to the standby database. This user must have permission to execute all replicated DDL commands at the standby database. The ddl_password parameter is the database user name’s password.
See the Replication Agent Reference Manual for details on setting these parameters.
When you replicate DDL in Oracle, you must use Oracle as the standby database. You cannot replicate DDL commands from Oracle to non-Oracle standby databases.
To replicate DDL, Replication Server must have a database-level replication
definition with replicate DDL set in the definition.
For details, see the Replication Server Reference Manual.
