############直接导入以,分隔列且以"包围的列到表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博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-667747/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-667747/