To disable replication for a marked sequence
Log in to the Mirror Replication Agent instance with the administrator login.
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.
A sequence must be marked for replication before replication
can be enabled or disabled for that sequence.
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 will not be captured for replication until replication is enabled again.
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.
