|
藍森林 http://www.lslnet.com 2006年8月26日 15:18
跪求講解,關於sqlldr
環境:oracle 9i
linux 9
各位大哥,我不算會數據庫的,但平時也要用用,導些數據,為了求快,我用sqlldr但是也是套用別人寫的,現在遇上了難題,我寫了一個input.ctl
load data
infile 'cncbill.CSV'
append into table sms_groupsend_cmcc
fields terminated by ','
(VC2MOBILE,FINTGRAL,FSTARTDATE,FENDDATE,FSTATE)
用來導下面這樣的數據:
"02558900024","1200","2004-7-1","2004-7-6",""
"05316580453","1700","2004-7-1","2004-9-4",""
"02481244066","1900","2004-7-2","2004-7-17",""
"01086144603","900","2004-7-5","2004-12-20",""
"01086984225","3660","2004-7-5","2004-12-27",""
"01081137165","50520","2004-7-6","2004-12-31",""
"01081423735","56500","2004-7-6","2004-12-30",""
"01086984223","2700","2004-7-6","",""
"02281540524","200","2004-7-6","",""
……
-----可是導不進去,還是請各位大哥幫忙,把握的ctl給改一改,謝謝了 |
跪求講解,關於sqlldr
google for "Oracle9i Database Utilities" |
跪求講解,關於sqlldr
是不是數據的問題,看看log文件。 |
跪求講解,關於sqlldr
別動不動就跪。鄙視! |
| |