OGG用NOCOMPRESSDELETES記錄所有列刪除值

 我們可以用ogg來實現交易事物跟蹤，比如記錄資料刪除前的值，

 有下面兩個引數來控制

COMPRESSDELETES和NOCOMPRESSDELETES

COMPRESSDELETES引數是預設值，只記錄刪除有主鍵的值

NOCOMPRESSDELETES 引數可以記錄所有列刪除值

 

以下是詳細解釋：

COMPRESSDELETES | NOCOMPRESSDELETES
Valid for Extract
Use the COMPRESSDELETES and NOCOMPRESSDELETES parameters for a log-based Extract group
to control the way columns are written to the trail record for delete operations.
COMPRESSDELETES, the default, causes Extract to write only the primary key to the trail for
delete operations. The key provides enough information to delete the correct target record,
while restricting the amount of data that must be processed.
NOCOMPRESSDELETES sends all of the columns to the trail. This becomes the default when a
table definition does not include a primary key or unique index. If a substitute key was
defined with the KEYCOLS option of TABLE, then those columns are written to the trail,
whether or not a real key was defined.
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.
These parameters do not affect data pumps.
Default COMPRESSDELETES
Syntax COMPRESSDELETES | NOCOMPRESSDELETES