Replication Agent 15.5 allows you to replicate only those DDL commands that affect replicated tables, instead of all DDL commands, using Oracle DDL filters.
In versions earlier than Replication Agent 15.5, if you enabled pdb_setrepdll, all DDL commands executed in the primary database were replicated. Limiting the replication of DDL commands lets you:
Enable DDL replication and override any prior version of enable or disable.
Exclude:
Table, procedures, and sequences
Owners
DDL commands or set of commands from replication
DDL commands executed by a certain database user from replication
Keep items in the DDL filter lists persisted with the Replication Agent instance.
To support this feature:
The pdb_setrepdll command has been updated with new usage and keywords.
A new command, ra_truncateddlfilters, has been introduced to truncate older versions of DDL filter lists in the RASD.
See the Replication Agent 15.5 Reference Manual and the Replication Agent 15.5 Administration Guide.
