控制文件示例:example.ctl
- options (SKIP=10000)
- LOAD DATA
- INFILE "Z:\1.txt"
- INFILE "Z:\2.txt"
- INFILE "Z:\3.txt"
- APPEND
- INTO TABLE HANG_UP
- (
- virtual_column FILLER terminated by 'calltime=',
- CALL_TIME DATE "YYYY-MM-DD HH24:MI:SS" terminated by ';imsi=',
- IMSI terminated by 'F;msisdn=',
- MSISDN terminated by ';des_msisdn=' "NVL(:MSISDN, '99999999999')",
- DES_MSISDN terminated by ';calltype=' "NVL(:DES_MSISDN, '99999999999')",
- CALL_TYPE terminated by ';LAC=',
- LAC terminated by ';CI=',
- CI terminated by ';',
- virtual_column2 FILLER
- )
导入cmd命令:
- sqlldr userid=zjlt/zjlt control='C:\ctl_hu\import_hu2.ctl' direct=true parallel=true log='F:\logs\hang_up_import_log2.txt' bad='F:\logs\h_u_.bad2.txt' errors=10000000 bindsize=512000