Disabling replication for a marked table
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setreptable command to verify that replication is enabled for the table:
pdb_setreptable pdb_table
Here, pdb_table is the name of the marked table for which you want to disable replication.
If the pdb_setreptable command returns information that the table is marked and has replication enabled, continue this procedure to disable replication for the table.
A table must be marked for replication before replication
can be enabled or disabled for the table.
Use the pdb_setreptable command to disable replication for the table:
pdb_setreptable pdb_table, disable
Here, pdb_table is the name of the marked table in the primary database for which you want to disable replication.
After replication is disabled for the table, transactions that affect the data in that table are not captured for replication until replication is enabled again.
You can use the pdb_setreptable command again to verify that replication is now disabled for the table:
pdb_setreptable pdb_table
Here, pdb_table is the name of the marked table for which you want to verify that replication is disabled.
