ORA-12899: value too large for column
来源:互联网 发布:天刀天香萝莉捏脸数据 编辑:程序博客网 时间:2024/05/16 01:19
ORA-12899: value too large for column (actual: 27, maximum: 20)
导入数据时报错以下错误,这是因为原来的数据库是GBK的,每个汉字两个字节,但新数据库是UTF-8的,每个汉字是三个字节,导致超过长度了。
ORA-12899: value too large for column (actual: 27, maximum: 20)
解决:
开始-->运行-->cmd,之后输入:"sqlplus /nolog",进入"SQL>"的提示,按照下面给出的命令依次执行就可以了:
SQL>connect username/password as SYSDBA;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
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
报字符集不兼容,此时下INTERNAL_USE指令不对字符集超集进行检查:
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP;
0 0
- ORA-12899: value too large for column
- ORA-12899: value too large for column
- ORA-12899 – Value too large for column string
- goldengate ORA-12899: value too large for column
- ORA-12899: value too large for...
- ORA-12899: value too large for column "SOAU"."SJQY_QTSBSPEC"."PROPERTY_6" (actual: 566, maximum: 500
- OGG: NLS_LENGTH_SEMANTICS报错信息ora-12899 value too large for column
- Oralce导入数据时提示ORA-12899错误value too large for column
- Oralce导入数据时提示ORA-12899错误value too large for column
- Oracle导数时报错:ORA-12899: value too large for column
- Caused by: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB:inserted value too large for column
- 在windows 下用tools导出导入Repository出错 value too large for column "SIEBEL"."S_ACCELERATOR
- Value too large for defined data type
- gcc 编译错误 Value too large for defined data type
- mysql: Packet for query is too large 和Data too long for column
- mysql: Packet for query is too large 和Data too long for column
- Data for Source Column 3(’Col3’) is too large for the specified buffer size.
- mysql导入备份文件(.sql)报错:Data too large for column
- poj1026--Cipher
- linux下安装python运行环境
- Rayeager PX2 增强板关于GPU的选择
- mysql锁机制总结
- opencv read_csv
- ORA-12899: value too large for column
- centos关于禁用触摸板
- windows下安装JDK
- Linux 采用后台模式导入oracle数据库dmp文件
- shell 数学运算
- 1285 山峰和分段
- MySQL线程共享内存参数
- JavaSE JNI 动态注册本地方法(c语言实现native层)
- html x消息提示框