oracle goldengate引數學習

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

 

以上這幾個引數對我們一些特殊處理操作非常有用處