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