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;