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 use this command, a replication definition must specify replicate minimal columns so that Replication Agent can send all columns for a row, not just those that have changed, in the autocorrection insert statement. However, Replication Agent for Oracle does not send all columns for an update statement to Replication Server. Consequently, when autocorrection is set on a replication definition for an Oracle primary, the insert statement applied by Replication Server may omit some columns. Replication Agent for Oracle therefore does not support use of the Replication Server set autocorrection command.
