藍森林首頁 | 返回主頁 | 本站地圖 | 站內搜索 | 聯繫信箱 |
 您目前的位置:首頁 > 自由軟件 > 技術交流 > 數 據 庫


    

藍森林 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

別動不動就跪。鄙視!



Copyright © 1999-2000 LSLNET.COM. All rights reserved. 藍森林網站 版權所有。 E-mail : webmaster@lslnet.com