如何使用sqlldr命令向oracle数据库…

环境windows xp 系统+oracle 9i 客户端

test.css文件如下： 其中第一行是表中字段的名字。

"ACTION_TYPE","CUSTOMER_ID","CUSTOMER_TYPE","NEW_FULL_NAME","OLD_FULL_NAME","CHARACTER","CORPORATION_NAME","REGISTER_FUND","FOUND_DT","STAT","MAIN_INDUSTRY_ID","MAIN_ADDR_ID","MAIN_ADDR_NAME","MAIN_ADDR_COUNTY_ID","MAIN_ADDR_POSTCODE","MAIN_LINKMAN_ID","CREATE_DT","UPDATE_DT","TELECOM_AREA_ID","AREA_CODE","CERTIFICATE_TYPE","CERTIFICATE_CODE","LINK_NAME","LINK_TEL","LINK_FAX_TEL","LINK_ELSE_TEL","LINK_MOBILE","LINK_ADDR_NAME","LINK_ADDR_PO"
"2","201206115086150","2","徐锦程","徐锦城","","","","","1","","201206110456206","海淀区西三旗花园三里76号","1","100000","201206110456206","2012-06-12 08:07:37","2012-06-12 08:11:45","1","010","1","110108198007162714","徐锦城","13810393792","","","","海淀区西三旗花园三里76号","100000"
"2","20000724728","2","尉欣","尉欣","","","","","1","1130","1100724728","金乡西小区甲29-4-5","10","101200","1100724728","2012-06-12 08:10:48","2012-06-12 08:11:50","10","010","1","110226196310080016","贝尔","13701053288","","","","金乡西小区甲29-4-5","101200"
"2","201206115086150","2","徐锦程","徐锦程","","","","","1","","201206110456206","海淀区西三旗花园三里76号","","100000","201206110456206","2012-06-12 08:13:01","2012-06-12 08:15:19","","010","1","110108198007162714","徐锦程","13810393792","","","","海淀区西三旗花园三里76号","100000"

 

test.ctl文件如下

load data
infile 'D:\test\test.csv' --此处是test.csv文件的位置
append into table t_cus_add --要导入的表名称
fields terminated by ',' OPTIONALLY ENCLOSED BY '"'   --分隔符说明
(
ACTION_TYPE,
CUSTOMER_ID,       
CUSTOMER_TYPE,    
NEW_FULL_NAME,     
OLD_FULL_NAME,     
CHARACTER,         
CORPORATION_NAME,  
REGISTER_FUND,     
FOUND_DT,          
STAT,             
MAIN_INDUSTRY_ID,  
MAIN_ADDR_ID,      
MAIN_ADDR_NAME,    
MAIN_ADDR_COUNTY_ID,
MAIN_ADDR_POSTCODE,
MAIN_LINKMAN_ID,   
CREATE_DT,         
UPDATE_DT,         
TELECOM_AREA_ID,   
AREA_CODE,         
CERTIFICATE_TYPE,  
CERTIFICATE_CODE,  
LINK_NAME,         
LINK_TEL,          
LINK_FAX_TEL,      
LINK_ELSE_TEL,     
LINK_MOBILE,       
LINK_ADDR_NAME,    
LINK_ADDR_POSTCODE
)

 

然后打开cmd ，进入ctl文件所在的目录

执行sqlldr user/passwd@132.77.127.84 control=test.ctl

sqlldr 数据库用户名/密码@你所在机器配置的连接到该数据库的名字 control=控制文件的名字