Unmarking a Sequence

Unmark an Oracle sequence.

1. Log in to the Replication Agent instance with the administrator login.
   
2. Determine if replication is enabled for the sequence:
   

   pdb_setrepseq pdb_seq

   where pdb_seq is the name of the sequence that 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 returns information that the specified sequence is not marked, you do not need to continue this procedure.

3. Disable replication for the sequence:
   

   pdb_setrepseq pdb_seq, disable

4. Unmark the sequence:
   

   pdb_setrepseq pdb_seq, unmark

   To force the unmark, use:

   pdb_setrepseq pdb_seq, unmark, force

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

   pdb_setrepseq pdb_seq