????1.??????????????input.bat
???????????sqlldr userid= dsa_test/dsa_test@dsa_test bindsize=5120000  readsize=9999999 control=input.ctl errors=999999999 parallel=true
????2.?????????????input.ctl
????yhq_session_120_13080704????????μ??????????????????????????????????·???????磺infile 'I:???????yhq_session_120_13080704.txt'
????GET_CDR????????????
????Date 'YYYYMMDD HH24:MI:SS' ????????yhq_session_120_13080704????????????????
????PS:????????????к??????????.dat???????????????
???????????
Load data
infile 'yhq_session_120_13080704.txt'
Append into table GET_CDR
FIELDS TERMINATED BY "??"  OPTIONALLY ENCLOSED BY '"'
(START_TIME Date 'YYYYMMDD HH24:MI:SS' ??
GTPXID ??
APN ??
MSISDN ??
IMEI ??
MOBILE_VENDOR ??
MOBILE_TYPE ??
MOBILE_SOFT  )
????3.????????????D???sqlldr?????????????CMD??????????
????4.????????????D:???
????5.???sqlldr????????cd sqlldr???
????6.????input.bat
???????????????????????