您好,欢迎来到UU财经。
搜索
您的当前位置:首页IGNOREDELETES,IGNOREUPDATES

IGNOREDELETES,IGNOREUPDATES

来源:UU财经


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

Copyright © 2019- uude.cn 版权所有

违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务