Disabling Replication for a Marked Sequence

Disable 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 sequence for which you want to disable replication.

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

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

    After replication is disabled for the sequence, any invocation of that sequence is not captured for replication until replication is enabled again.

  4. Verify that replication is now disabled for the sequence:
    pdb_setrepseq pdb_seq