Re: SQL Loader err: Field in data file exceeded maximum specified length

Dug Birdzell <dug_at_lab.com> wrote:

>Hi:
>
>Posted a message to this effect a while back & I thought I'd try again
>as I'm experiencing the same problem.
>
>I am attempting to load ASCII data into an oracle table which has
>54 fields, some as long as 1950 characters.
>
>The ASCII data is comma-delimited and quote-enclosed, and the record
>length of my test file does not exceed 4610 bytes.
>
>On each uploaded record I get a message like:
>
>Record 26: Rejected - Error on table SPOT.EMPLOYMENT, column TEXT1.
>Field in data file exceeded maximum specified length

How long is your TEXT1 column?

Apparently the data is longer than that. Received on Thu Feb 20 1997 - 00:00:00 CET