用sqlldr
创建控制文件in.ctlload data
append
into table table_name
fields terminated by '|'
(
a char(30),
b char(50),
c char(100),
d number
)文本文件内容格式10300108200|XPB65|后盖|0030200525 |3.42000008
10300108200|XPB65-113S|桶|0030200877 |15.52000046执行sqlldr username/pw control=c:\in.ctl data=c:\in.txt
创建控制文件in.ctlload data
append
into table table_name
fields terminated by '|'
(
a char(30),
b char(50),
c char(100),
d number
)文本文件内容格式10300108200|XPB65|后盖|0030200525 |3.42000008
10300108200|XPB65-113S|桶|0030200877 |15.52000046执行sqlldr username/pw control=c:\in.ctl data=c:\in.txt
到哪里可以找到呢/.我的oracle是oracle816版本的
oracle安装目录bin文件夹里面
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch03.htm#1656