Disabling replication for marked sequence

StepsDisabling replication for a marked sequence

  1. Log in to the Replication Agent instance with the administrator login.

  2. Use the pdb_setrepseq command to verify that replication is enabled for the sequence:

    pdb_setrepseq pdb_seq
    

    Here, pdb_seq is the name of the marked sequence you want to disable replication for.

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

    NoteA sequence must be marked for replication before replication can be enabled or disabled for that sequence.

  3. Use the pdb_setrepseq command to disable replication for the sequence:

    pdb_setrepseq pdb_seq, disable
    

    Here, pdb_seq is the name of the marked sequence for which you want to disable replication.

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

  4. You can use the pdb_setrepseq command again to verify that replication is now disabled for the sequence:

    pdb_setrepseq pdb_seq
    

    Here, pdb_seq is the name of the marked sequence for which you want to verify that replication is disabled.