1.92 INSERTUPSERTS | NOINSERTUPSERTS

Valid For

Replicat.

Default is INSERTUPSERTS.

Trail file format 19.1 supports UPSERT operation type. Older trail file format must be used with INSERTUPSERTS to convert UPSERT record to INSERT record.

By default, specifying INSERTUPSERTS, enables Replicat to apply UPSERT record as INSERT. If the row exists, Replicat overwrites the row by the new record.

If the output trail format is 18.1 or older, the INSERTUPSERTS option is required, otherwise the primary Extract fails. Primary Extract always writes UPSERT record as INSERT record for 18.1 or older trail, and you need to specify OVERRIDEDUPS option to apply the INSERT record that was originally UPSERT.

If the user exit module version is 5 or older, INSERTUPSERTS is required. UPSERT record is converted to INSERT record for the user exit version 5 or older, as well as user exit stats record count.

If the output trail format 18.1 or older is specified with NOINSERTUPSERTS, primary Extract fails. User exit module version 6 (enable from 19.1 release) supports UPSERT record type and stats count if NOINSERTUPSERTS is specified. If user exit module is version 5 or older and NOINSERTUPSERTS is specified, primary Extract, pump or Replicat fail.

If UPSERT operation is applied as INSERT by specifying INSERTUPSERTS, stats still count as UPSERT operation.

UPSERT operation type is only output if NOINSERTUPSERTS is specified, otherwise output as INSERT.

Parallel Replicat and Oracle Integrated Replicat does not support both UPSERT and INSERT converted from UPSERT, and fallback to non-integrated classic Replicat mode.