Valid For

Extract

Description

Use the LOGALLSUPCOLS parameter to control the writing of supplementally logged columns specified with ADD TRANDATA or ADD SCHEMATRANDATA to the trail.

LOGALLSUPCOLS supports integrated Replicat (for Oracle database) and the Oracle GoldenGateConflict Detection and Resolution feature (CDR). The supplementally logged columns are a union of the scheduling columns that are required to ensure data integrity across parallel Replicat threads and the conflict detection and resolution (CDR) columns. Scheduling columns are primary key, unique index, and foreign key columns. Including all of these supplementally logged columns satisfies the requirements of both CDR and dependency computation in parallel Replicat processing.

LOGALLSUPCOLS causes Extract to do the following with these supplementally logged columns:

• Automatically includes in the trail record the before image for UPDATE operations.

• Automatically includes in the trail record the before image of all supplementally logged columns for both UPDATE and DELETE operations.

• As a reminder, certain columns cannot be part of supplemental logging in Oracle. If you want those columns to be present in the trail file, even if they did not change, you must use FETCHOPTIONS MISSINGCOLS in the Extract parameter file.

For Extract versions older than 12c, you can use GETUPDATEBEFORES and NOCOMPRESSDELETES parameters to satisfy the same requirement. See GETUPDATEBEFORES | IGNOREUPDATEBEFORES and COMPRESSUPDATES | NOCOMPRESSUPDATES for more information.

LOGALLSUPCOLS | NOLOGALLSUPCOLS takes precedence over the following parameters, if used:

• GETUPDATEBEFORES | IGNOREUPDATEBEFORES

• COMPRESSDELETES | NOCOMPRESSDELETES

• COMPRESSUPDATES | NOCOMPRESSUPDATES for before images, but COMPRESSUPDATES | NOCOMPRESSUPDATES takes precedence over LOGALLSUPCOLS on after images.

Default

LOGALLSUPCOLS

Syntax

LOGALLSUPCOLS