oracle goldengate参数学习INSERTDELETES

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

oracle goldengate参数学习

1:INSERTDELETES和NOINSERTDELETES
INSERTDELETES | NOINSERTDELETES
Valid for Replicat
Use the INSERTDELETES and NOINSERTDELETES parameters to control whether or not Oracle
GoldenGate converts source delete operations to insert operations on the target database.
The parameters are table-specific. One parameter remains in effect for all subsequent MAP
statements, until the other parameter is encountered.
Default NOINSERTDELETES
Syntax INSERTDELETES | NOINSERTDELETES

2:INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
Valid for Replicat
Use the INSERTMISSINGUPDATES and NOINSERTMISSINGUPDATES parameters to control whether or
not Oracle GoldenGate inserts a record based on the source record when the target record
does not exist.
INSERTMISSINGUPDATES inserts the missing update but should only be used when the source
database uses non-compressed updates. It can work with a database that uses compressed
updates if the target database allows NULL to be used for the missing column values.
When the default of NOINSERTMISSINGUPDATES is in effect, a missing record causes an error,
and the transaction may abend depending on REPERROR settings.
The INSERTMISSINGUPDATES and NOINSERTMISSINGUPDATES parameters are table-specific. One
parameter remains in effect for all subsequent MAP statements, until the other parameter
is encountered.
Default NOINSERTMISSINGUPDATES
Syntax INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES

3:INSERTUPDATES | NOINSERTUPDATES
INSERTUPDATES | NOINSERTUPDATES
Valid for Replicat
Use the INSERTUPDATES and NOINSERTUPDATES parameters to control whether or not Oracle
GoldenGate converts uncompressed update operations to insert operations. The
parameters are table-specific. One parameter remains in effect for all subsequent MAP
statements, until the other parameter is encountered.
Default NOINSERTUPDATES
Syntax INSERTUPDATES | NOINSERTUPDATES

4:UPDATEDELETES | NOUPDATEDELETES
Valid for Replicat
Use the UPDATEDELETES parameter to convert delete operations to update operations for all
MAP statements specified after it in the parameter file. Use NOUPDATEDELETES to turn off
UPDATEDELETES.
Default NOUPDATEDELETES
Syntax UPDATEDELETES | NOUPDATEDELETES

以上这几个参数对我们一些特殊处理操作非常有用处

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