sqlload.cmd
- pause
- sqlldr user/pass@tnsdb control.ctl skip=1 rows=2000 bindsize=8192000
- pause
control.ctl
- LOAD DATA
- INFILE ‘Rating201001.csv‘
- APPEND
- INTO TABLE "TBL_SELL"
- FIELDS TERMINATED BY ‘,‘ OPTIONALLY ENCLOSED BY ‘"‘
- TRAILING NULLCOLS
- (
- SRC_TYPE_CODE,
- YEAR_MONTH,
- P_INDEX,
- PROVINCE,
- CITY,
- COUNTRY,
- SHOP_NAME "trim(:SHOP_NAME)",
- SHOP_CODE,
- BRAND_NAME,
- SELL_COUNT,
- SELL_MONEY,
- SHOP_RATING,
- TYPE_CODE "decode(:SRC_TYPE_CODE,10,5,:SRC_TYPE_CODE)"
- )
oracle sqlldr使用（导入速度快，但对数据本身的处理功能弱）
原文：http://www.cnblogs.com/adolfmc/p/4270221.html
