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博客

goldengate for oracle 92 当源端的表的列数超过32列时，add trandata报错

最新文章