使用sqlldr載入外部檔案中的資料到Oracle中(轉)

使用sqlldr載入外部檔案中的資料到Oracle中(轉)[@more@]C:Documents and Settings wang>sqlldr userid=scott/tiger@dbdev01 control=c: est.ctl log=c: est.log
SQL*Loader: Release 9.2.0.1.0 - Production on 星期二 3月 7 13:31:39 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
達到提交點，邏輯記錄計數64
達到提交點，邏輯記錄計數81
C:Documents and Settings wang>

控制檔案：
load data
infile 'c:lot.csv'
badfile 'c:ad.txt'
discardfile 'c:discardfile.txt'
append
into table apm_lot_merge
fields terminated by ',' optionally enclosed by '"'
(
LOT_NO,
MERGE_SEQ,
MERGE_DATE,
MERGE_LOT_NO,
MERGE_LOT_QTY
)
lot.csv檔案是逗號分隔的csv檔案