(1)编写控制文件 abc.ctl
OPTIONS(skip=1,rows=128)
load data
infile './id_data.csv'
badfile './bad.txt'
append into table tmp_appid_noticedate
fields terminated by ','
optionally enclosed by '"'
trailing nullcols
(applicant,
notice_date timestamp"YYYY-MM-DD HH24:MI:SS")
终端运行命令
(1)执行sqlldr
sqlldr username/password@10.xx.xx.102:1550/EHID control=abc.ctl log=./test.log
(2)进入sqlldr
sqlldr username/password@//10.xx.xx.102:1550/EHID
create table tmp_appid_noticedate(
applicant varchar(20),
notice_date date)