goldengate for oracle 92 當源端的表的列數超過32列時,add trandata報錯

msdnchina發表於2011-04-27

add trandata報錯的前提條件:

1.oracle 92 資料庫

2.源端的表沒有主鍵,沒有唯一鍵。

3.源端的表的列數超過32個列。

如下的例子:

GGSCI (rhel41) 2> add trandata GYHT.GY_CLHTK

2011-04-26 21:20:20 WARNING OGG-00869 No unique key is defined for table GY_CLHTK. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2011-04-26 21:20:20 WARNING OGG-00706 Failed to add supplemental log group on table GYHT.GY_CLHTK due to ORA-02257: maximum number of columns exceeded, SQL ALTER TABLE "GYHT"."GY_CLHTK" ADD SUPPLEMENTAL LOG GROUP "GGS_GY_CLHTK_30398" ("HTH","HTLB","GFBM","GF","XFBM","XF","QDDD","QDNIAN","QDYUE","QDRI","CPBM","CPMC","CPGG","CPSB","JLDW","SL","DJ","ZJE","J.

--以上是沒有加過pk或者uk的情況。

--以下是加過pk後,再add trandata 的情況
GGSCI (rhel41) 3> add trandata GYHT.GY_CLHTK

Logging of supplemental redo data enabled for table GYHT.GY_CLHTK.

GGSCI (rhel41) 4>

[@more@]

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

相關文章