DDL Replication

Replication of data definition language (DDL) commands is supported, but only to Oracle databases. You cannot replicate DDL commands from Oracle to non-Oracle replicate databases.

Replication of DDL commands is enabled or disabled in Replication Agent using the pdb_setrepddl command. Replication Agent for Oracle can disable or enable the replication of specific DDL commands by object, owner, statement, or user. Replication Server uses the ddl_username parameter to execute DDL commands in the replicate database as the same user who executed the DDL commands in the primary database.

See Replication Agent Reference Manual > Command Reference > pdb_setrepddl and Replication Agent Reference Manual > Configuration Parameters > ddl_username for details on using pdb_setrepddl and ddl_username.