sqlldr userid=btupayprod/Tyzf2012 control=/home/bestpay/gt/demo.ctl direct=true parallel=true data=/home/bestpay/gt/425_26.csv
1、在要导入数据的用户下面新建表:
create table TMP_CZY_0420_2
(
cust_name VARCHAR2(200),
id_card_no VARCHAR2(20),
mobile_no VARCHAR2(20),
bussiness_type VARCHAR2(20),
pre_cert_amount VARCHAR2(20),
cert_date VARCHAR2(30),
expiration_date VARCHAR2(30),
status VARCHAR2(10)
);
2、创建脚本文件,格式是 ctl 结尾。
load data
infile 'D:\quick_noquick\quick_noquick.csv'
into table tmp_czy_0420_3
append
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(cust_name ,
id_card_no ,
mobile_no,
bussiness_type ,
pre_cert_amount ,
cert_date ,
expiration_date ,
status
)
3、运用sqlldr的导入语句:
sqlldr userid=crpay/Rfs2F1\(p control=/home/pcloud/test.ctl direct=true parallel=true data=/home/pcloud/VIP_白名单_0506.csv
sqlldr userid=crpay/Rfs2F1\(p control=/home/pcloud/test.ctl direct=true parallel=true data=/home/pcloud/VIP_白名单_0506.csv
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29346172/viewspace-2158163/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29346172/viewspace-2158163/