当前位置: 代码迷 >> Ruby/Rails >> oracle sqlload error "Field in data file exceeds maximum length"
  详细解决方案

oracle sqlload error "Field in data file exceeds maximum length"

热度:205   发布时间:2016-04-29 02:23:25.0
oracle sqlload error "Field in data file exceeds maximum length"
?

Symptoms

Loading long columns using sqlldr,the following error is reported:

" Record 1: Rejected - Error on table CRM_ATIC_HEADER_DIF, column LONG_DESC.
Field in data file exceeds maximum length "

Cause

In the control file,char(n) had to be specified for all the "varchar2" and "long" columns that were there in the table definition
  相关解决方案