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 Mirror Replication Agent can send all columns for a row, not just those that have changed, in the autocorrection insert statement. However, Mirror 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. Mirror Replication Agent for Oracle therefore does not support use of the Replication Server set autocorrection command.
