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

Hi:

[Quoted] 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

even though I specify

FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' in the control file.

Any help would be most appreciated!

Yours,

Dug Birdzell                                          
Administrator, Programmer,  Engineer                       

3221 Connecticut, NW #502 Washington, DC 20008 1-202-237-1478 www.butterfly.net/dug Received on Thu Feb 20 1997 - 00:00:00 CET