goldengate 同步無主鍵表

scott.bonus表無主鍵無唯一索引，若是在gg源端發出，會導致gg目的端abend，除非目的端複製進程參數檔案有APPLYNOOPUPDATES 或者ALLOWNOOPUPDATES  參數)

update scott.t1 set ename='bos' where ename='bos2';

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

 

所以在目標端的設定檔中加入參數 APPLYNOOPUPDATES 或者ALLOWNOOPUPDATES  參數