Enabling replication for sequences

StepsEnabling replication for a marked sequence

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

  2. Use the pdb_setrepseq command to verify that replication is disabled for the sequence:

    pdb_setrepseq pdb_seq
    

    Here, pdb_seq is the name of the marked sequence you want to enable replication for.

    If the pdb_setrepseq command returns information that the sequence is marked and has replication disabled, continue this procedure to enable replication for the sequence.

    NoteA sequence must be marked for replication before replication can be enabled or disabled for the sequence.

  3. Use the pdb_setrepseq command to enable replication for the sequence:

    pdb_setrepseq pdb_seq, enable
    

    Here, pdb_seq is the name of the marked sequence for which you want to enable replication.

    After replication is enabled for the sequence, any invocation of that sequence is replicated.

  4. You can use the pdb_setrepseq command again to verify that replication is now enabled 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 enabled.