I'm loading a large table into Oracle9i on a Windows platform from a flat file that I generated from a Sybase database on a UNIX platform using sqlldr.
The table definitions are identical.

One of the fields is a varchar255 character field that often contains several carriage returns.

Several records are rejected in the load on this field, with the 'Field in data file exceeds maximum length' error.

I have increased the size of the target field to 300, 500 and finally 1000 bytes - but is still rejects the same records.

I have had this problem before, and found that by deleting all the carriage returns I can load up the table - but this table has over a million records, and is rejecting way too many of them.

Any ideas? This is not making sense to me!

Thanks for your help!