############直接导入以,分隔列且以"包围的列到表dept；而且导入内容也在control文件中

-bash-3.1$ more insert_dept.ctl
load data
infile *
append into table dept ###有四种插入表的方式：append,truncate,replace,insert
fields terminated by ',' optionally enclosed by '"'
(deptno,dname,loc)
begindata
50,dba,"beijing" #####下列为要入库的内容
60,developer,"xianan"
70,"manager","hainan"

开始导入

#######加上log及bad便于分析是否导入出错进行调整

sqlldr userid=scott/system control=/oracle/insert_dept.ctl log=/oracle/insert_dept.log bad=/oracle/insert_dept.bad

ITPub博客

oracle sqlloader导入数据的一系列方法

最新文章