Unmarking a sequence

StepsUnmarking a sequence

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

  2. Use the pdb_setrepseq command to confirm that the sequence is marked in the primary database:

    pdb_setrepseq pdb_seq
    

    Here, pdb_seq is the name of the sequence that you want to unmark.

    Consider the following:

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

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

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

    pdb_setrepseq pdb_seq, disable
    

    Here, pdb_proc is the name of the sequence that you want to unmark.

  4. Use the pdb_setrepseq command to remove the replication marking from the sequence:

    pdb_setrepseq pdb_seq, unmark
    

    Here, pdb_seq is the name of the sequence that you want to unmark.

    If you need to force the unmark, you can use the following command:

    pdb_setrepseq pdb_seq, unmark, force
    
  5. Use the pdb_setrepseq command to confirm that the sequence is no longer marked for replication:

    pdb_setrepseq pdb_seq
    

    Here, pdb_seq is the name of the sequence in the primary database that you unmarked.