ORA-12899:列的值太大 [英] ORA-12899: value too large for column

问题描述

我以提要的形式从erp系统获取数据，特别是提要中的一列长度仅为15.

I am getting data from erp systems in the form of feeds ,in particular one column length in feed is 15 only.

在目标表中，对应的列也为长度varchar2(15)，但是当我尝试将其加载到db中时，它显示如下错误:

In target table also corresponded column also length is varchar2(15) but when I am trying to load same into db it showing error like:

ORA-12899:该值对于emp_name列而言过大(实际值:16，最大值: 15)

ORA-12899: value too large for column emp_name (actual: 16, maximum: 15)

我不能增加列的长度，因为它是生产中的基本表.

I cant increase the column length since it is base table in the production.

推荐答案

浏览此博客，该问题已通过将列数据类型从varchar(100)更改为varchar(100 char)为我解决.在我的情况下，数据包含一些变音符号.

have a look into this blog, the problem resolved for me by changing the column datatype from varchar(100) to varchar(100 char). in my case the data contains some umlaut characters.

http://gerardnico.com/wiki/database/oracle/byte_or_character

这篇关于ORA-12899:列的值太大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！