oracle update dec0de,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

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