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

来源：互联网发布：office软件下载 mac版编辑：程序博客网时间：2024/06/07 04:52

环境windows xp 系统+oracle9i 客户端

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-1208:07:37","2012-06-1208:11:45","1","010","1","110108198007162714","徐锦城","13810393792","","","","海淀区西三旗花园三里76号","100000"
"2","20000724728","2","尉欣","尉欣","","","","","1","1130","1100724728","金乡西小区甲29-4-5","10","101200","1100724728","2012-06-1208:10:48","2012-06-1208:11:50","10","010","1","110226196310080016","贝尔","13701053288","","","","金乡西小区甲29-4-5","101200"
"2","201206115086150","2","徐锦程","徐锦程","","","","","1","","201206110456206","海淀区西三旗花园三里76号","","100000","201206110456206","2012-06-1208:13:01","2012-06-1208: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.84control=test.ctl

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

0 0