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
再次匯入正常,問題解決
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 字符集檢視與修改Oracle
- MySQL 檢視與修改預設字符集MySql
- yolov8 face 錯誤修改YOLO
- Oracle 字符集修改Oracle
- 修改sqlserver字符集SQLServer
- 修改oracle字符集Oracle
- 修改MySQL字符集MySql
- oracle修改字符集Oracle
- mysql 字符集修改MySql
- MySQL修改字符集MySql
- oracle字符集修改Oracle
- oracle 修改字符集Oracle
- ORACLE11G解決ORA-00845錯誤Oracle
- mysql 解決字符集錯誤 正確摘錄MySql
- 修復svn hook導致的字符集錯誤Hook
- [譯] 修改 Git 錯誤的高明方法Git
- 安裝oracle11g遇到的Oracle11g Error in invoking target類錯誤OracleError
- Oracle11g新增密碼錯誤延遲驗證Oracle密碼
- ORACLE11G ORA-600[kkdcacr ptn_kxcp]錯誤Oracle
- DB2字符集,查詢中文錯誤DB2
- oracle 字符集錯誤情況處理簡單方法Oracle
- 修改linux字符集Linux
- oracle之修改字符集Oracle
- Windows修改cmd字符集Windows
- 怎樣修改檢視Oracle字符集及怎樣修改字符集 ztOracle
- oracle11g更改資料庫字符集Oracle資料庫
- wmi修改ip返回錯誤值2147942705
- ORACLE11g DataGuard手工建立錯誤的解決方案(一)Oracle
- ORACLE11g DataGuard手工建立錯誤的解決方案(二)Oracle
- Linux下安裝oracle11g和錯誤詳解LinuxOracle
- MySQL DB字符集修改方法MySql
- Oracle修改資料字符集Oracle
- 修改資料庫字符集資料庫
- 修改oracle client 的字符集Oracleclient
- 修改sql server 的字符集SQLServer
- 微信支付WxpayAPI_php_v3 錯誤修改APIPHP
- android AVC錯誤修改許可權方法Android
- Oracle11g修改MEMORY_TARGETOracle