Create and Drop Subscriptions

When database and table or function subscriptions are used concurrently, there are several procedures to follow when you create or drop those subscriptions

If you create a database subscription that references a table with an existing table subscription, make sure you do not overwrite the replicated table when synchronizing databases:
1. Back up the replicated table.
2. Use dump and load to synchronize the replicate database.
3. Copy the replicated table back into the replicate database.
Drop a table or function subscription with suspension. After the replicate DSI is suspended, you can dematerialize or resynchronize the replicate table or function.
When a database subscription exists that includes a table and you want to add a table subscription, make sure you define the table subscription using bulk materialization. Defining the table subscription does not stop database replication for the table. Database replication for a table stops when its table subscription is activated.
When dropping a database subscription, you must manually purge all replicated tables that do not have table subscriptions. Replication Server does not dematerialize replicated tables.