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.
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