SQL*Loader-00510 Physical record in data file (string) is longer than the maximum(number)
Cause: The datafile has a physical record that is too long.
Action: Use CONCATENATE or CONTINUEIF. Break up the physical records.
最初由 winy_huang 发布
[B]SQL*Loader-00510 Physical record in data file (string) is longer than the maximum(number)
Cause: The datafile has a physical record that is too long.
Action: Use CONCATENATE or CONTINUEIF. Break up the physical records. [/B]
如果是这样的话,那么发生错误以至导入结束时的下一行文本应该就是错误发生的位置了?可是我试过只导入下一行,也是成功的,那说明下一行并没有超过长度限制了?还是不懂啊。
[oracle@backup zfk]$ sqlldr userid=ba/esun2009ba@ba control=userpaylog.ctl
SQL*Loader: Release 10.2.0.3.0 - Production on Fri May 22 10:48:00 2009
Copyright (c) 1982, 2005, Oracle.All rights reserved.
SQL*Loader-510: Physical record in data file (uldrdata.txt) is longer than the maximum(1895825408)
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.