2.31 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