以下是我的sqlldr执行后的log日志,大家帮我看看这个日志,日志没有报错能不能确定,我的数据肯定插入到数据库的表中了。谢谢。SQL*Loader: Release 10.2.0.1.0 - Production on Tue Feb 17 09:19:25 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Control File: /xxx/xxx/xxx/xxx/xxx/xxx/3/xxx.xml.ctl
Data File: /xxx/xxx/xxx/xxx/xxx/xxx/3/xxx.xml
Bad File: /xxx/xxx/xxx/xxx/xxx/bad/xxx/xxx.bad
Discard File: /xxx/xxx/xxx/xxx/xxx/bad/xxx/xxx.xml.dsc
(Allow all discards)Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct - with parallel option.
Silent options: FEEDBACK
Load is UNRECOVERABLE; invalidation redo is produced.Table YMSG1, loaded from every logical record.
Insert option in effect for this table: APPEND Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
DEVICENUM FIRST * CHARACTER
Terminator string : '∮∮'
CLUEID NEXT * CHARACTER
Terminator string : '∮∮'
CLUETIMES NEXT * CHARACTER
Terminator string : '∮∮'
READFLAG NEXT * CHARACTER
Terminator string : '∮∮'
STATUS NEXT * CHARACTER
Terminator string : '∮∮'
CHECKINTIME NEXT * DATE yyyy-mm-dd hh24:mi:ss
Terminator string : '∮∮'
CLIENTIP NEXT * CHARACTER
Terminator string : '∮∮'
CLIENTPORT NEXT * CHARACTER
Terminator string : '∮∮'
SERVERIP NEXT * CHARACTER
Terminator string : '∮∮'
SERVERPORT NEXT * CHARACTER
Terminator string : '∮∮'
CAPTURETIME NEXT * DATE yyyy-mm-dd hh24:mi:ss
Terminator string : '∮∮'
PHONENUM NEXT * CHARACTER
Terminator string : '∮∮'
ACCOUNT NEXT * CHARACTER
Terminator string : '∮∮'
CLIENTMAC NEXT * CHARACTER
Terminator string : '∮∮'
OPTYPE NEXT * CHARACTER
Terminator string : '∮∮'
CONTENT NEXT 1024 CHARACTER
Terminator string : '∮∮'
YMSGNUM NEXT * CHARACTER
Terminator string : '∮∮'
PEERYMSGNUM NEXT * CHARACTER
Terminator string : '∮∮'
YMSGID SEQUENCE (MAX, 1)
Table YMSG1:
1 Row successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null. Date cache:
Max Size: 1000
Entries : 1
Hits : 1
Misses : 0Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576Total logical records skipped: 0
Total logical records read: 1
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 1
Total stream buffers loaded by SQL*Loader load thread: 0Run began on Tue Feb 17 09:19:25 2009
Run ended on Tue Feb 17 09:19:26 2009Elapsed time was: 00:00:00.98
CPU time was: 00:00:00.03
Data File: /xxx/xxx/xxx/xxx/xxx/xxx/3/xxx.xml
Bad File: /xxx/xxx/xxx/xxx/xxx/bad/xxx/xxx.bad
Discard File: /xxx/xxx/xxx/xxx/xxx/bad/xxx/xxx.xml.dsc
(Allow all discards)Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct - with parallel option.
Silent options: FEEDBACK
Load is UNRECOVERABLE; invalidation redo is produced.Table YMSG1, loaded from every logical record.
Insert option in effect for this table: APPEND Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
DEVICENUM FIRST * CHARACTER
Terminator string : '∮∮'
CLUEID NEXT * CHARACTER
Terminator string : '∮∮'
CLUETIMES NEXT * CHARACTER
Terminator string : '∮∮'
READFLAG NEXT * CHARACTER
Terminator string : '∮∮'
STATUS NEXT * CHARACTER
Terminator string : '∮∮'
CHECKINTIME NEXT * DATE yyyy-mm-dd hh24:mi:ss
Terminator string : '∮∮'
CLIENTIP NEXT * CHARACTER
Terminator string : '∮∮'
CLIENTPORT NEXT * CHARACTER
Terminator string : '∮∮'
SERVERIP NEXT * CHARACTER
Terminator string : '∮∮'
SERVERPORT NEXT * CHARACTER
Terminator string : '∮∮'
CAPTURETIME NEXT * DATE yyyy-mm-dd hh24:mi:ss
Terminator string : '∮∮'
PHONENUM NEXT * CHARACTER
Terminator string : '∮∮'
ACCOUNT NEXT * CHARACTER
Terminator string : '∮∮'
CLIENTMAC NEXT * CHARACTER
Terminator string : '∮∮'
OPTYPE NEXT * CHARACTER
Terminator string : '∮∮'
CONTENT NEXT 1024 CHARACTER
Terminator string : '∮∮'
YMSGNUM NEXT * CHARACTER
Terminator string : '∮∮'
PEERYMSGNUM NEXT * CHARACTER
Terminator string : '∮∮'
YMSGID SEQUENCE (MAX, 1)
Table YMSG1:
1 Row successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null. Date cache:
Max Size: 1000
Entries : 1
Hits : 1
Misses : 0Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576Total logical records skipped: 0
Total logical records read: 1
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 1
Total stream buffers loaded by SQL*Loader load thread: 0Run began on Tue Feb 17 09:19:25 2009
Run ended on Tue Feb 17 09:19:26 2009Elapsed time was: 00:00:00.98
CPU time was: 00:00:00.03
1 Row successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.根据这个提示信息可知,有一行导入成功,没有错误数据
Discard File: /xxx/xxx/xxx/xxx/xxx/bad/xxx/xxx.xml.dsc这个文件就知道哪些记录没有load
检查你的log里面列出来的BadFile 和 Discard File就可以了,如果有不符合格式或者其他错误导致没有导入的数据会明确列在这些文件里面的
楼主为什么不检查一下,或者把这两个文件的内容贴出来
如果都导入的话,这个文件的内容就是空的