sqlldr倒入csv数据文件的问题？求救

Question

可以看一下导入的日志，导入时会自动生成一个.log的文件，里面会有详细说明

Answer 1

还有，我的*.bad文件中显着了没有倒入成功的数据。

Answer 2

这是我的部分数据
DAA01,JH,
DAA01,CYJH1,
DAA01,CYJH2,
DAA01,yt,
DAA01,QKDY,
DAA01,DYDM,
DAA01,CW,
DAA01,SKJDDS1,600<x<4500
DAA01,SKJDDS2,SKJDDS1<X<4500
DAA01,SKYCDS1,SKYCDS1<X<4500
DAA01,SKYCDS2,
DAA01,JSHD,
DAA01,YXHD,0.2<X<100
DAA01,CS,
DAA01,MQJB,
DAA01,SJJB
DAA01,TCJB
DAA01,CM
DAA01,KM
DAA01,DM
DAA01,DWDM
DAA01,JLZH
DAA01,YPFL
DAA01,TCRQ
DAA01,CYRQ
DAA01,SCBZ
DAA01,ZSRQ
DAA01,ZQRQ
DAA01,QQRQ
DAA01,HSRQ
DAA01,JSRQ1
DAA01,YSDCYL,7<x<50
DAA01,BHYL,5<x<50
DAA01,YSDCWD,30<x<300
DAA01,BGRQ,
DAA01,BZ,
DAA011,JH,
DAA011,BGRQ,
DAA011,BGYY,
DAA011,JB,
DAA011,YT,
DAA011,QKDY,
DAA011,DYDM,
DAA011,CW,
DAA011,SKJDDS1,600<x<4500
DAA011,SKJDDS2,SKJDDS1<x<4500
DAA011,SKYCDS1,600<x<4500
DAA011,SKYCDS2,SKYCDS1<x<4500
DAA011,JSHD,0.2<x<100
DAA011,YXHD,0.2<x<100
DAA011,CS,0<x<50
DAA011,YPFL,
DAA011,JSRQ1,
DAA011,YSDCYL,7<x<50
DAA011,BHYL,5<x<50
DAA011,YSDCWD,30<x<300
DAA011,JDCYL,0<=x
DAA011,JDCSL,0<=x
DAA011,JDCQL,0<=x
DAA011,JDZSL,0<=x
DAA011,JDZQL,
DAA011,JDJH,
DAA02,JH,
DAA02,YT,
DAA02,QKDY,
DAA02,DYDM,
DAA02,ZZBX,0<x
DAA02,HZBY,0<x
DAA02,JD,
DAA02,WD1,
DAA02,PTMC,
DAA02,SJRQ,
DAA02,SJJB,
DAA02,JX,
DAA02,JJ,0<x<500
DAA02,SGDWDM,
DAA02,KZRQ,
DAA02,WZRQ,
DAA02,WJRQ,
DAA02,WZCWMC,

Answer 3

.log 文件中是怎么说的？

Answer 4

input.ctl为
load data　　　　　　　
　　infile 'daatable.csv'　　　　　　 
　　append into table rules　　　　
　　fields terminated by ','
    --加入一句  你在试试看
    TRAILING NULLCOLS　
　　(tableName,fieldName,rule)