$su - oracle
第一步:
建一个test.CTL文件内容
load data
infile '/home/oracle/test1.dat'
into table test1
fields terminated by ","
(f1 ,
f2 ,
f3 )
第二步:
sqlldr scott/tiger control=test.CTL data=test1.dat
第一步:
建一个test.CTL文件内容
load data
infile '/home/oracle/test1.dat'
into table test1
fields terminated by ","
(f1 ,
f2 ,
f3 )
第二步:
sqlldr scott/tiger control=test.CTL data=test1.dat
http://community.freebsdchina.org/document.php?topic=1737&forum=41