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);