For DDL to be replicated, the pdb_setrepddl command must be set to enable. If pdb_setrepddl is set to enable, all DDL in your primary database is replicated. Also, you must set the ddl_username and the ddl_password.
For Oracle: To replicate DDL:
Mirror Replication Agent requires a unique user name that will have authority to execute all DDL commands at the standby database.
Replication Server must have a database-level replication definition with replicate DDL set in the definition.
For details about configuration property ddl_username and for database-level replication definition, refer to the Mirror Replication Agent Reference Manual.
Enabling replication for DDL in the primary database
Log in to the Mirror Replication Agent administration port.
Use the pdb_setrepddl command without an argument to determine if replication is already enabled for DDL in the primary database:
pdb_setrepddl
If the pdb_setrepddl command returns information that replication is enabled, you do not need to continue this procedure.
If the pdb_setrepddl command returns information that replication is not enabled for DDL, continue this procedure to enable replication for DDL.
Use the pdb_setrepddl command to enable replication for DDL:
pdb_setrepddl enable
After replication is enabled for the DDL, you can begin replicating your primary database.
