Enabling Replication for a Marked Sequence

Enable replication for a marked sequence.

  1. Log in to the Replication Agent instance with the administrator login.
  2. Determine whether or not replication is enabled for the sequence:
    pdb_setrepseq pdb_seq

    where pdb_seq is the name of the sequence for which you want to enable replication.

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

    Note: A sequence must be marked for replication before replication can be enabled or disabled for the sequence.
  3. Enable replication for the sequence:
    pdb_setrepseq pdb_seq, enable

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

  4. Use pdb_setrepseq again to verify that replication is now enabled for the sequence:
    pdb_setrepseq pdb_seq