HVAR and Oracle

No primary database reconfiguration is necessary for UDB or Microsoft SQL Server to take advantage of HVAR. Oracle, by default, logs only minimal columns for update operations, so supplemental logging must be enabled for all columns in tables marked for replication.

To enable supplemental logging from Replication Agent for Oracle, use the ra_set_autocorrection command as described in the Replication Agent Reference Manual.

Note: Replication Agent for Oracle does not support use of the autocorrection feature for large-object (LOB), LONG, LONG RAW, or user-defined datatypes. See the Replication Agent Primary Database Guide for information about the limitations of the autocorrection feature.