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