oracle sqlloader匯入資料的一系列方法

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