本文介绍了ORA-12899:列的值太大的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我以提要的形式从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:列的值太大的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-01 15:30