oracle sqlldr加载数据

sqlldr userid=user/password control=ctlfile direct=true --使用绝对路径

ctl文件格式如：
load data
infile '/home/oracle/memory/ddquerytime.dat'
"str '|!n'"  ——行分割符
badfile '/home/oracle/memory/ddquerytime.bad'
discardfile '/home/oracle/memory/ddquerytime.dis'
truncate
into table des.ddquerytime
fields terminated by '|!' ——列分割符
trailing nullcols
(
code  char "nvl(trim(:name),' ')" ——处理空格及空串转为空格
,name
)