Oracle's sql*loader-00510 Error

Today a storage program complains

sql*loader-00510 physical record in data file (string) is longer than the maximum (number)

It was obviously caused by Sqlloader.

The Official document explains the following

Cause:the DataFile has a physical record this is too long.

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Action:use concatenate or Continueif. Break up the physical records.

As a result of the test, the reason is that there are different formats of carriage return lines in the import file.

There are ^m$ and $ two carriage return lines, so the unified conversion of the Dos2unix command to the Linux carriage return line.

Dos2unix filename

Solve the problem.

This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/725495