首頁 >資料庫 >mysql教程 >IGNOREDELETES,IGNOREUPDATES

IGNOREDELETES,IGNOREUPDATES

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原創
2016-06-07 16:03:241736瀏覽

有时候,我们在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;

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn