GETINSERTS | IGNOREINSERTS
Valid For
Extract and Replicat
Description
Use the GETINSERTS
and IGNOREINSERTS
parameters to control whether or not INSERT
operations are processed by Oracle GoldenGate. 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 GETINSERTS
threads in one set of MAP
statements, and specify the IGNOREINSERTS
threads in a different set of MAP
statements.
Default
GETINSERTS
Syntax
GETINSERTS | IGNOREINSERTS
Example
This example shows how you can apply GETINSERTS
and IGNOREINSERTS
selectively to different MAP
statements, each of which represents a different thread of a coordinated Replicat.
IGNOREINSERTS MAP sales.loc, TARGET sales.loc, THREAD (3); GETINSERTS MAP sales.cust, TARGET sales.cust, THREAD (1); MAP sales.ord, TARGET sales.ord, THREAD (2);
Parent topic: Oracle GoldenGate Parameters