COMPRESSDELETES | NOCOMPRESSDELETES
Valid for
Extract
Description
Use COMPRESSDELETES
and NOCOMPRESSDELETES
to control the way columns are written to the trail record for delete operations.
COMPRESSDELETES
will extract only the primary key fields or columns for deleted operations. NOCOMPRESSDELETES
, the default, sends all columns to the trail. By sending only the primary key, Oracle GoldenGate has all of the data required to delete the target record, while restricting the amount of data that must be processed. This creates a net performance gain.
COMPRESSDELETES
and NOCOMPRESSDELETES
can be used globally for all TABLE
statements in the parameter file, or they can be used as on-off switches for individual TABLE
statements.
Default
NOCOMPRESSDELETES
Syntax
COMPRESSDELETES