var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: curious sqlldr error
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!