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

 

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

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-709158/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-709158/