使用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文件
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文件
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10617731/viewspace-961665/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10617731/viewspace-961665/