文字內容檔 04_D_NATIONALITY.CSV 

C,本國籍 Y,外國籍 2,外籍配偶 1,大陸配偶

CTL檔  04_D_NATIONALITY.ctl

OPTIONS (ERRORS=1000) LOAD DATA CHARACTERSET ZHT16MSWIN950 INFILE '04_D_NATIONALITY.CSV' badfile 'tmp\04_D_NATIONALITY_ERR.log' TRUNCATE INTO TABLE D_NATIONALITY WHEN (1:2) = 'A1' FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( NATINO "trim(:NATINO)", NATINM "trim(:NATINM)" )

執行CMD 

sqlldr userid=user/pass@orcl control=04_D_NATIONALITY.ctl log=04_D_NATIONALITY_EXE.log readsize=10000 bindsize=10000 direct=true errors=10000