OGG-01163 Bad column length (32) specified for column in table
首先新建一個.prm檔案
源庫
cd /ogg/dirdef
vi sss.prm
defsfile ./xxx.def,purge
userid ogguser, PASSWORD oggpassword
table schema.tablename;
儲存:
#defgen paramfile sss.prm
生成定義檔案sss.def
再進檔案進行修改欄位列。或者已經修改,不用在這裡修改。
直接傳遞到目標端/ogg/dirdef/sss.def
在R進行中配置
SOURCEDEFS ./dirdef/sss.def OVERRIDE
啟動程式即可。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28869493/viewspace-2219297/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- alter table set unused column
- mysql specified key was too long與Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- SQLAlchemy Table(表)類方式 – Table類和Column類SQL
- SAP Fiori Elements 裡 Smart Table column 的寬度問題
- Unknown column ‘name‘ in ‘field list‘ ; bad SQL grammar []; nested exception is com.mysql.jdbc.excepExceptionMySqlJDBC
- Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (Doc ID 971833.1)GoOracleAI
- Vue進階(么伍么):el-table-column :key應用Vue
- SQLITE_ERROR - table sap_capire_bookshop_books has no column named currencySQLiteErrorAPI
- el-table 的 el-table-column 的key使用Math.random() 篩選列random
- [20200904]12c invisible column impdp segment_column_id.txt
- Index column size too large. The maximum column size is 767 bytes.Index
- CSS column-gapCSS
- CSS column-ruleCSS
- CSS column-widthCSS
- CSS column-spanCSS
- 5.6.7. Renaming a Column
- Sorting arrays in NumPy by column
- data too long for column
- 1709 - Index column size too large. The maximum column size is 767 bytes.Index
- [Err] 1709 - Index column size too large. The maximum column size is 767 bytes.Index
- ExtJs的Column佈局JS
- <el-table-column prop="item_no" label="料號"/>設定最小寬度
- MySQL建立表失敗:Index column size too large. The maximum column size is 767 bytesMySqlIndex
- 錯誤:duplicate column name: picstitle
- PostgreSQL DBA(164) - pgAdmin(Drop column)SQL
- Flutter 之 Row、Column詳解Flutter
- flutter佈局-1-columnFlutter
- SAP UI5 Form 表單 Column Layout 下的 Column 個數分配問題UIORM
- MySQL 5.7 到 5.6,出現 Index column size too large. The maximum column size is 767 bytesMySqlIndex
- Specified key was too long; max key length is 1000 bytes
- WPF Livecharts C# Column name changeEchartsC#
- Leetcode 168. Excel Sheet Column TitleLeetCodeExcel
- Flutter基礎元件Row&ColumnFlutter元件
- Flutter之Row/Column用法詳解Flutter
- Oracle 12C Statistics on Column GroupsOracle
- MySQL資料庫index column size too large. the maximum column size is 767 bytes問題解決MySql資料庫Index
- python json讀取資料:ValueError: Extra data: line 77 column 2 - line 16485 column 1 (char 1159 - 227243)PythonJSONError
- mysql5.7 資料匯入5.6 Index column size too large. The maximum column size is 767 bytes.MySqlIndex