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 replicate or target database. This user must have permission to execute all replicated DDL commands at the target database. The ddl_password parameter is the password corresponding to the database user name. In addition, the ddl_username database user must have permission to issue the ALTER SESSION SET CURRENT_SCHEMA command for any primary database user that might issue a DDL command to be replicated. See the Replication Agent Reference Manual.
When you replicate DDL in Oracle, use Oracle as the replicate database. You cannot replicate DDL commands from Oracle to non-Oracle replicate databases.
