表結構變更後出現的ERROR OGG-01161 Bad column index (88),ogg-01161column

來源:互聯網
上載者:User

表結構變更後出現的ERROR OGG-01161 Bad column index (88),ogg-01161column

2014-07-31 09:38:31 ERROR OGG-01668 PROCESS ABENDING.2014-07-31 09:38:31 ERROR OGG-01161 Bad column index (88) specified for table WIP.WIP_PARAMETERS, max columns = 88.網上有說是表結構不一致的。但是我已經仔細比對了每個欄位,是一致的。那為什麼初始化同步就出問題呢?應該是打補丁導致源端表結構發生了變化,比如增加了欄位。 此時要重建源端表結構的defgen定義檔案,再把定義檔案放到目標端。defgen檔案的作用是,記錄了源端的表結構,然後我們再把這個檔案放到目標端,在目標端應用SQL時就能根據defgen檔案與目標端表結構,來做一定的轉換。



相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.