Disabling Replication for a Marked Table

Disable replication for a marked table.

  1. Log in to the Replication Agent instance with the administrator login.
  2. Determine if the table is marked in the primary database:
    pdb_setreptable pdb_table

    where pdb_table is the name of the primary database table for which you want to disable replication.

    If pdb_setreptable returns information that the specified table is marked and has replication enabled, continue this procedure to disable replication for the table.

    Note: A table must be marked for replication before replication can be enabled or disabled for the table.
  3. Disable replication for the table:
    pdb_setreptable pdb_table, disable

    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.

  4. Verify that replication is now disabled for the table:
    pdb_setreptable pdb_table