sqlldr数据导入问题，在线等

[denty]

我现在用sqlldr做数据导入的时候，有的列用空值，SQLLDR好象就不认识了，哪位有办法？？？

错误如下：


Record 1: Rejected - Error on table WORKER, column SEX
ORA-02359: Field in data file exceeded maximum specified length
Record 2: Rejected - Error on table WORKER, column BH
ORA-02360: Column not found before end of logical record (use TRAILING NULLCOLS)

[zmgowin]

1、数据文件有问题，column sex长度过大，检查数据文件和表结构
2、在控制文件中加入TRAILING NULLCOLS

[denty]

load data
infile 'result.csv'
into table resultxt
(resultid char terminated by ',',
website char terminated by ',',
ipport char terminated by ',',
status char terminated by whitespace)


上面是我的控制文件，那个TRAILING NULLCOLS加在哪儿呢？？？

[denty]

帅哥们帮帮菜鸟啊。。。。

[zmgowin]

load data
infile 'result.csv'
into table resultxt
fields terminated by ','
TRAILING NULLCOLS
(resultid,
website,
ipport,
status)

[denty]

偶找到了 ，是加在括号之前，谢谢隐者。。。。。