sqlldr 快速导入数据

1. 创建control 文件  vi c.ctl
load data
infile '/home/oracle/12.csv'
append into table tmpuser
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(
CLIENTID,
CREATETIME date "yyyy/mm/dd hh24:mi:ss",
USERID
)

2. 执行命令  因为12.csv  文件是excel 文件  里面有title ，需要跳过一行
sqlldr userid=orcl/orcl@orcl control=c.ctl skip=1

3. 数据类型
"cid","date","uid"
"170621015","2017/6/21 09:46:59","11717936"
"170621015","2017/6/21 09:50:30","11889450"
"170621015","2017/6/21 09:50:34","11174411"
"170621015","2017/6/21 09:51:18","10540536"
"170621015","2017/6/21 09:51:39","10705286"
"170621015","2017/6/21 09:52:03","11260362"
"170621015","2017/6/21 09:54:44","11562738"
"170621015","2017/6/21 09:55:20","11784940"
"170621015","2017/6/21 09:56:08","11172482"
"170621015","2017/6/21 09:57:53","11430736"
"170621015","2017/6/21 09:59:32","11591045"
....


tmpuser  表结构
Name       Type         Nullable Default Comments 
---------- ------------ -------- ------- -------- 
CLIENTID   VARCHAR2(50) Y                         
CREATETIME DATE         Y                         
USERID     NUMBER       Y