求教sqlload的问题

zekezhao

sqlldr tsapro/itc123 control=emp.ctl data=test.dat log=emp.log  rows=10000 binds
ize=8192000 bad= homeoraclezhd.bad
控制文件
options (parallel=true)
load data

infile '/home/oracle/test.dat'
badfile '/home/oracle/homeoraclezhd.bad'
discardfile '/home/oracle/homeoraclezhd.dsc'
append
into table pay_dtl_bak

fields terminated by ','
(
a,
b,
c
)
c字段的类型是varchar2(1024)
报错
Record 35: Rejected - Error on table xxxx, column c.
Field in data file exceeds maximum length

MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table PAY_DTL_BAK:
  0 Rows successfully loaded.
  52 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

Space allocated for bind array:                8187372 bytes(774 rows)
Read   buffer bytes: 8192000
Total logical records skipped:          0
Total logical records read:           101
Total logical records rejected:        52
Total logical records discarded:        0

请问怎么样改脚本？

renxiao2003

应该是列超出了对应表列的最大长度，所以不能导入！查看对应列是不是有空格或者真的是表列长度不够！

zekezhao

fields terminated by ','
(
a,
b,
c (varchar2 ,1024)
)
这样写可以吗