oracle 导入数据的sqlldr命令

create table test4
(
time    varchar2(50),
ip      varchar2(50),
path_type   varchar2(50),
version varchar2(100),
imsi    varchar2(100),
old_version  varchar2(50),
channel_id   varchar2(50),
status  int
)

 新建一个后缀是load.ctl的文件  内容如下  

load data
infile 'd:\4.txt'
into table test4
fields terminated by ','
(time,ip,path_type,version,imsi,old_version ,channel_id,status)

在cmd 中执行如下命令 sqlldr userid=mcp/mcp@65.40  control='d:\load.ctl' log='d:\log.log'  bad='d:\bad.bad'