Replication Server set autocorrection Command

The Replication Server set autocorrection command prevents failures that would otherwise be caused by missing or duplicate rows in a replicated table.

The set autocorrection command corrects discrepancies that may occur during materialization by converting each update or insert operation into a delete followed by an insert.

To set autocorrection from:

Replication Agent for one or all tables in the primary database, use the Replication Agent ra_set_autocorrection command as described in the Replication Agent Reference Manual.
Replication Server, use the set autocorrection command in a replication definition. You must do this from Replication Server, however, because Replication Agent cannot alter the autocorrection setting on a replication definition.

Replication Agent for Oracle does not support use of the autocorrection feature for large-object (LOB), LONG, LONG RAW, or user-defined datatypes. Also, pds_username must have the ALTER ANY TABLE privilege to execute these commands:

ALTER TABLE tablename ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
ALTER TABLE tablename DROP SUPPLEMENTAL LOG DATA (ALL) COLUMNS;