使用SQLLDR命令导入:
CTL文件如下:
load data
infile 'e:\20100507.txt'
into table gd_car_info
(
COMPID char terminated by ',' ,
VID char terminated by ',' ,
CITY char terminated by ',' ,
CARNUM char terminated by ',' ,
CARP char terminated by ',' ,
VIN char terminated by ',' ,
CARFADONG char terminated by ',',
BAOAN char terminated by ',',
TIMESTA char terminated by ',',
MEY char terminated by ',',
ZE char terminated by ',',
DIE char terminated by ',',
TIMEEND char terminated by whitespace
)
'e:\20100507.txt' 这个文件如果只有几百条数据是可以正常导入的,也提示成功了;但是我要导入的记事本有205M大小,执行了命令以后就没反应了!没提示成功也没提示失败!请问为什么呢?
CTL文件如下:
load data
infile 'e:\20100507.txt'
into table gd_car_info
(
COMPID char terminated by ',' ,
VID char terminated by ',' ,
CITY char terminated by ',' ,
CARNUM char terminated by ',' ,
CARP char terminated by ',' ,
VIN char terminated by ',' ,
CARFADONG char terminated by ',',
BAOAN char terminated by ',',
TIMESTA char terminated by ',',
MEY char terminated by ',',
ZE char terminated by ',',
DIE char terminated by ',',
TIMEEND char terminated by whitespace
)
'e:\20100507.txt' 这个文件如果只有几百条数据是可以正常导入的,也提示成功了;但是我要导入的记事本有205M大小,执行了命令以后就没反应了!没提示成功也没提示失败!请问为什么呢?
sqlldr username/password control=youcontrol.ctl direct=true streamsize=10485760
sqlldr username/password control=youcontrol.ctl direct=true log='文件名'加一个日志看看,最后导入完成后可以看日志
另外你的控制文件也不对劲,我给你一个我这边的例子Load data
Append into table nbrs_cost
fields terminated by ','
trailing nullcols
(
GoodsID ,
ShopID ,
VenderID ,
OrginMCD ,
ContractCost ,
Cost ,
PayTypeID ,
RebateRate ,
StartDate date "YYYYMMDD",
EndDate date "YYYYMMDD",
ClearFlag ,
ClearDate date "YYYYMMDD",
DKRate ,
costtaxrate ,
produceflag ,
pstartdate date "YYYYMMDD",
penddate date "YYYYMMDD",
MinOrder ,
RetFlag ,
OldOfferQty ,
OldFreeQty ,
OfferQty ,
FreeQty ,
Flag ,
PromFlag ,
SheetID
)