|
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.
|