Alter Database Replication Definitions

Adding or dropping database replication definitions does not affect table or function subscriptions

When you alter a database replication definition, you replace the existing database replication filter or add the filter category to the database replication filters, if it is a new category.

Replication Server places a marker in the inbound queue and allows the DIST to process the command. The new filter is applied to transactions committed after the marker.

If a table subscriptions exists, no action is required.
If no table subscription exists, you must include the dsi_suspended clause in the alter database replication definition command, or manually materialize or dematerialize the table.

To alter table and function replication definitions, use the replication definition change request process where Replication Server coordinates the propagation of replication definition changes and data replication automatically.