2011年3月31日星期四

How to resolve SQL error : SQL*Loader-510

The issue happend when we tried to import a csv data file via sql loader.

The loader finished in error with following message in log file :

- US : SQL*Loader-510: Physical record in data file (XXX/XXXXXX/XX.csv) is longer than the maximum
- F : SQL*Loader-510: Enreg. physique dans fichier de données (XXX/XXXXXX/XX.csv) plus long que max

The CSV file has been uploaded correctly on the server. And there is none line in CSV file which seems very long.

In our case here, the problem comes from the CSV file generation format in Excel. In fact, two CSV saving format are proposed by Excel, we choosed the format CSV macintosh. If we choose another one format CSV DOS, the error would not be occured.

没有评论:

发表评论