Oracle Goldengate用NOCOMPRESSDELETES记录所有列删除值

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:24

Oracle Goldengate用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

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】