oracle too large,Oralce导入数据时提示ORA-12899错误value too large for column

Oralce导入数据时提示ORA-12899错误value too large for column

www.111cn.net 更新:2013-11-21 编辑:future 来源:转载

今天在把以前备份的数据导入到oracle时，发现提示 ORA-12899错误value too large for column了，这个就是数据太大的问题，下面我来把解决过程与各位同学分享一下。

从生产导出数据到测试,出现如下错误

ORA-02374: conversion error loading table "SWTONLINE"."TBL_TRANS_LOG_HISTORY_B"

ORA-12899: value too large for column MER_ADDR_NAME (actual: 54, maximum: 40)

初步估计为字符集差异导致.中文在UTF-8里占3个字节，ZHS16GBK里占2个字节

查看测试库字符集

代码如下 复制代码

sys@PROD>select * from V$NLS_PARAMETERS

2  ;

PARAMETER                                                        VALUE

---------------------------------------------------------------- ----------------------------------------

NLS_LANGUAGE                                                     SIMPLIFIED CHINESE

NLS_TERRITORY                                                    CHINA

NLS_CURRENCY                                                     ￥

NLS_ISO_CURRENCY                                                 CHINA

NLS_NUMERIC_CHARACTERS                                           .,

NLS_CALENDAR                                                     GREGORIAN

NLS_DATE_FORMAT                                                  DD-MON-RR

NLS_DATE_LANGUAGE