Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: field in data file exceeds max length in SQLLOADER

Re: field in data file exceeds max length in SQLLOADER

From: Rognvald Bjarne <wear_u_out_at_nospam.hotmail.com>
Date: Wed, 23 Aug 2000 13:52:35 -0600
Message-ID: <MXVo5.225$uzc7.6095060@news.randori.com>

"Krusty" <danparker276_at_my-deja.com> wrote in message news:8nvdbv$40u$1_at_nnrp1.deja.com...
> Does anyone know why I'm getting this error message
> 'Field in data file exceeds maximum length'
> my field is a varchar2(4000), and I get this error when I truncate that
> field down to 300. If I truncate it down to 30 (in my data) it works
> fine

In the 300 length format is it perhaps not picking up the delimiters? Received on Wed Aug 23 2000 - 14:52:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US