IGNOREDELETES,IGNOREUPDATES,ignoredeletes
有時候,我們在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;
ignore,neglect的不同?
ignore 是故意不理睬,故意忽視
He completely ignored all these facts as though they never existed.
他完全無視這一切, 好象它們根本不存在似的。
She saw him coming but she ignored him.
她看見他走過來, 但裝做沒看到他。
negelect 是漏做,疏忽的意思.
fall into neglect 漸被忽視[忽略]
in a state of neglect 處於無人照管的狀態
treat sb. with neglect 怠慢某人
參考資料:baidu
omit,ignore在英語中有什不同?
ignore 忽視 不理踩 主觀性的不理睬性較強
omit 疏忽 遺漏 忘記 多是客觀性的遺漏疏忽了
參考資料:zhidao.baidu.com/question/48900872.html