Disabling Replication for a Marked Sequence

Disable replication for a marked sequence.

  1. Log in to the Replication Agent instance with the administrator login.
  2. Determine whether or not replication is enabled for the sequence:
    pdb_setrepseq pdb_seq

    where pdb_seq is the name of the sequence for which you want to disable replication.

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

    Note: A sequence must be marked for replication before replication can be enabled or disabled for the sequence.
  3. Disable replication for the sequence:
    pdb_setrepseq pdb_seq, disable

    After replication is disabled for the sequence, any invocation of that sequence is not captured for replication until replication is reenabled.

  4. Use pdb_setrepseq again to verify that replication is now disabled for the sequence:
    pdb_setrepseq pdb_seq