新建test.ctl文件
load data
infile 'D:\ngram\reBuild3grams\rebuild-googlebooks-eng-all-1gram-20090715-0.csv'
BADFILE 'D:\ngram\reBuild3grams \data.bad'
DISCARDFILE 'D:\ngram\reBuild3grams \data.dsc'
DISCARDMAX 1000
APPEND
into table one_gram
fields terminated by "\t"
( first_word, times, pages, books )
打开cmd命令行界面,输入:
sqlldr userid=programer/programer@orcl control=D:\ngram\reBuild3grams\test.ctl log=D:\ngram\reBuild3grams\test.log
http://blog.csdn.net/robinson_0612/article/details/5926296(有许多oracle相关文章)
