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>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/161195/viewspace-1049169/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/161195/viewspace-1049169/