问题描述
我以提要的形式从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:
我不能增加列的长度,因为它是生产中的基本表.
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:列的值太大的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!