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.Note: By default, Replication Agent for Oracle filters SYS user
DDL and if you want to replicate the SYS user DDL, you can manually remove the
filter.
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.