Set the ddl_username and ddl_password parameters.
To replicate DDL in Oracle, use pdb_setrepddl to set filtering rules accordingly. You must also set the Replication Agent ddl_username and ddl_password parameters. ddl_username is the database user name used to execute the replicated DDL command at the target database. This user must have permission to execute all replicated DDL commands at the target database. ddl_password is the corresponding password for ddl_username. 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.
The value of ddl_username cannot be the same as the maintenance user defined in Replication Server for the replicate connection. If these names are the same, a Replication Server error results.
The value of the ddl_username parameter is sent in the LTL for all replicated DDL statements. When DDL is replicated, Replication Server connects to the replicate database using the user ID and password specified by the ddl_username and ddl_password parameters. Replication Server then issues:
ALTER SESSION SET CURRENT_SCHEMA=user
where user is the user ID that generated the DDL operation at the primary database. The actual DDL command is then executed against the replicate database. If the user ID specified in ddl_username does not have permission to issue the ALTER SESSION SET CURRENT_SCHEMA or to execute the DDL command against the user schema, the command fails.