Enabling Replication for a Marked Sequence

Enable replication for 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 sequencefor 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. Verify that replication is now enabled for the sequence:
    pdb_setrepseq pdb_seq