sqlldr %UserID/%PassWord@%Host data=%Date log=%Log bad=%Bad ERRORS=10000 control=%Ctl silent=(FEEDBACK,HEADER)
control文件定义
LOAD DATA
--INFILE './data/MDESIGN.DAT
INTO TABLE MDESIGN
INSERT
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED '"'
TRAILING NULLCOLS
(
Design ,
Model ,
CarTypeCount ,
SaveDate date"YYYY-MM-DD HH24:MI:SS",
DefaultLineType ,
OutLineMax ,
DeleteFlag
)