mysql delete ignore_IGNOREDELETES,IGNOREUPDATES

有时候，我们在ogg目标端应用数据的时候不想应用更新或者删除操作，这时候我们就可以使用IGNOREDELETES, IGNOREUPDATES参数 GETDELETES | IGNOREDELETES Valid for Extract and Replicat Use the GETDELETES and IGNOREDELETES parameters to control whethe

有时候，我们在ogg目标端应用数据的时候不想应用更新或者删除操作，这时候我们就可以使用IGNOREDELETES, IGNOREUPDATES参数

GETDELETES | IGNOREDELETES

Valid for Extract and Replicat

Use the GETDELETES and IGNOREDELETES parameters to control whether or not Oracle

GoldenGate processes delete operations. These parameters are table-specific. One

parameter remains in effect for all subsequent TABLE or MAP statements, until the other

parameter is encountered.

Default GETDELETES

Syntax GETDELETES | IGNOREDELETES

GETUPDATES | IGNOREUPDATES

Valid for Extract and Replicat

Use the GETUPDATES and IGNOREUPDATES parameters to control whether or not Oracle

GoldenGate processes update operations. The parameters are table-specific. One

parameter remains in effect for all subsequent TABLE or MAP statements, until the other

parameter is encountered.

Default GETUPDATES

Syntax GETUPDATES | IGNOREUPDATES

例如：

REPLICAT zbdba

ASSUMETARGETDEFS

USERID ogg_zbdba,PASSWORD ogg_oracle

IGNOREDELETES

IGNOREUPDATES

MAP zbdba.test, TARGET zbdba.test;

本文原创发布php中文网，转载请注明出处，感谢您的尊重！