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
Automatically includes in the trail record the before image of all supplementally logged columns for both
For Extract versions older than 12c, you can use
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 | NOCOMPRESSUPDATESfor before images, but
COMPRESSUPDATES | NOCOMPRESSUPDATEStakes precedence over
LOGALLSUPCOLSon after images.