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
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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7199859/viewspace-704133/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
OGG 新增复制表实施步骤
请登录后发表评论
登录
全部评论
最新文章
- 《手把手教你用AI安装Oracle 19c（附详细步骤）》
- 《3小时手工安装Oracle，用AI只需15分钟》
- oracle 20c 不支持non-cdb架构
- 当删除oracle数据库user时发生row cache lock 等待事件
- 通过 Oracle_Cloud_Infrastructure oci 云认证考试
- ORA-32021: parameter value longer than 255 characters 解决方法
- online清理oracle 监听日志推荐的做法
- 分享查看统计信息非常好的脚本
- impdp 导入 schema的数据时会自动创建对应的用户
- 如何移动asm磁盘组内的数据文件到另外一个磁盘组
