Unmarking a Sequence

Unmark a sequence.

1. Log in to the Replication Agent instance with the administrator login.
   
2. Determine whether or not the sequence is marked in the primary database:
   

   pdb_setrepseq pdb_seq

   where pdb_seq is the name of the sequence you want to unmark.

   • If pdb_setrepseq returns information that the specified sequence is marked, continue this procedure to unmark the sequence.

   • If pdb_setrepseq does not return information that the specified sequence is marked, you do not need to continue this procedure.

3. Disable replication for the sequence:
   

   pdb_setrepseq pdb_seq, disable

4. Remove the replication marking from the sequence:

   pdb_setrepseq pdb_seq, unmark

   To force the unmarking, use:

   pdb_setrepseq pdb_seq, unmark, force

5. Confirm that the sequence is no longer marked for replication:

   pdb_setrepseq pdb_seq