Posted on 2006-10-27 10:56:47-07 by sherinpearl
Sqlldr issue with Oracle 8i
I'm loading a dynamically created CSV file to a database table using sqlldr. The csv file has the fist line blank (which cannot be avoided). In Oracle 9i sqlldr loads this file. But in Oracle 8i, sqlldr gives me an error : SQL*Loader-510: Physical record in data file (D:\RSEnduInterface\RSJavaService\HourlyStationGenFile.csv) is longer than the maximum(1048576) I have tried SKIP thinking that it will skip the blank line, but it didn't. If i remove the first blank line & then try with Oracle 8i, it gets loaded without any problems. Please advise on how to load this file using oracle 8i.
Direct Responses: Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.