Valid For
Extract and Replicat
Description
Use the GETUPDATES and IGNOREUPDATES parameters to control whether or not Oracle GoldenGate processes UPDATE operations. These parameters are table-specific. One parameter remains in effect for all subsequent TABLE or MAP statements, until the other parameter is encountered.
Because you can selectively enable or disable these parameters between MAP statements, you can enable or disable them for different threads of a coordinated Replicat. Specify the GETUPDATES threads in one set of MAP statements, and specify the IGNOREUPDATES threads in a different set of MAP statements.
Default
GETUPDATES
Syntax
GETUPDATES | IGNOREUPDATES
Example
This example shows how you can apply GETUPDATES and IGNOREUPDATES selectively to different MAP statements, each of which represents a different thread of a coordinated Replicat.
GETUPDATES MAP sales.cust, TARGET sales.cust, THREAD (1); MAP sales.ord, TARGET sales.ord, THREAD (2); IGNOREUPDATES MAP sales.loc, TARGET sales.loc, THREAD (3);