############直接导入以,分隔列且以"包围的列到表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