IMP-00019错误与修改oracle11g字符集

环境是cesos6.4  oracle11gR2在imp导入数据时报错：
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "XJ"."ALL_GOODS_DECL"."DEST_NAME" (actual: 51, maximum: 50)
Column 1 512104
Column 2 Q650300114000620
Column 3 650300114020889
Column 4 650300114021175E
Column 5 6500910018
Column 6 6500700148
Column 7 29-SEP-2014:00:00:00
Column 8 6
Column 9 
Column 10 ASIA STAR METAL TRADING INC
Column 11 ***

经查数据库字符集是AL32UTF8，下面修改为ZHS16GBK


[oracle@xen1607250002 config]$ sqlplus  /nolog


SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 27 14:34:32 2016


Copyright (c) 1982, 2009, Oracle.  All rights reserved.


SQL> connect  / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area 2388422656 bytes
Fixed Size                  2215664 bytes
Variable Size            1358954768 bytes
Database Buffers         1006632960 bytes
Redo Buffers               20619264 bytes
Database mounted.
Database opened.
SQL> shutdown  immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup  mount;
ORACLE instance started.


Total System Global Area 2388422656 bytes
Fixed Size                  2215664 bytes
Variable Size            1358954768 bytes
Database Buffers         1006632960 bytes
Redo Buffers               20619264 bytes
Database mounted.
SQL> alter session set sql_trace=true; 


Session altered.


SQL> alter system  enable  restricted  session;


System altered.


SQL> alter system  set job_queue_processes=0;


System altered.


SQL> alter system  set aq_tm_processes=0;


System altered.


SQL> alter database open;


Database altered.


SQL> alter database  character set ZHS16GBK;
alter database  character set ZHS16GBK
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set




SQL> ALTER database  character set INTERNAL_USE  ZHS16GBK;


Database altered.


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area 2388422656 bytes
Fixed Size                  2215664 bytes
Variable Size            1358954768 bytes
Database Buffers         1006632960 bytes
Redo Buffers               20619264 bytes
Database mounted.
Database opened.
SQL> select userenv('language') from dual;


USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

再次导入正常，问题解决

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26870952/viewspace-2122678/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26870952/viewspace-2122678/