goldengate 目的端程式引數APPLYNOOPUPDATES 和ALLOWNOOPUPDATES

msdnchina發表於2011-09-14


以下語句(scott.bonus表無主鍵無唯一索引)若是在gg源端發出,會導致gg目的端abend(除非目的端複製程式引數檔案有APPLYNOOPUPDATES 或者ALLOWNOOPUPDATES 引數)

update scott.bonus set ename='lei2' where ename='lei2';


gg目的端abend時,dirrpt下的rpt檔案報錯如下:


2011-09-14 09:35:23 ERROR OGG-01168 Encountered an update for target table SCOTT2.BONUS, which has no unique key defined. KEYCOLS can be used to define a key.
Use ALLOWNOOPUPDATES to process the update without applying it to the target database.
Use APPLYNOOPUPDATES to force the update to be applied using all columns in both the SET and WHERE clause.

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1055042/,如需轉載,請註明出處,否則將追究法律責任。

相關文章