oracle imp file data

 sqlldr username/password control=youcontrol.ctl direct=true streamsize=10485760

eurusd.ctl

---------------------------------------------------

load
infile "C://DAT_MT_EURUSD_M1_201201.txt"
infile "C://DAT_MT_EURUSD_M1_201202.txt"
infile "C://DAT_MT_EURUSD_M1_201203.txt"
infile "C://DAT_MT_EURUSD_M1_201204.txt"
infile "C://DAT_MT_EURUSD_M1_201205.txt"
infile "C://DAT_MT_EURUSD_M1_201206.txt"
infile "C://DAT_MT_EURUSD_M1_2002.txt"
infile "C://DAT_MT_EURUSD_M1_2003.txt"
infile "C://DAT_MT_EURUSD_M1_2004.txt"
infile "C://DAT_MT_EURUSD_M1_2005.txt"
infile "C://DAT_MT_EURUSD_M1_2006.txt"
infile "C://DAT_MT_EURUSD_M1_2007.txt"
infile "C://DAT_MT_EURUSD_M1_2008.txt"
infile "C://DAT_MT_EURUSD_M1_2009.txt"
infile "C://DAT_MT_EURUSD_M1_2010.txt"
infile "C://DAT_MT_EURUSD_M1_2011.txt"

append into table EURUSD
fields terminated by ","
trailing nullcols
(
DATES ,
TIMES,
OPINET1,
OPINET2,
OPINET3,
OPINET4,
STATUS
)

posted on 2012-10-19 08:09  adolfmc  阅读(322)  评论(0编辑  收藏  举报