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.
You can use autocorrection in two ways:
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.
To set autocorrection from 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 the following commands:
ALTER TABLE tablename ADD
SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
ALTER TABLE tablename DROP
SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
