Hi gurus,

After using bcp to export a big table's data from SQL Server, I used SQL*Loader to load that data into Oracle. Among 3 million rows of records, 4,000+ records were rejected because 'Field in data file exceeds maximum length'.

However, I have EXACTLY the same table definition in both dbms which is varchar2(2000). So if that column(CallEventLog) fits SQL Server, it should fit Oracle as well. And also, by looking at the data in the .bad file, I don't think they are even close to 2000 characters. I even substr(:CallEventLog, 1, 2000) in my control file for that column, but still got the same erros.

Any idea?

FYI -- the problem column(CallEventLog)'s data have '\n' in it. Does it play a role inside?

I am using Oracle 9i on a win2K box.

Let me know if you need any other info.

Thanks a lot,
Elaine