export.log的内容如下所示,193条记录中有11条没有导入。
SQL*Loader: Release 10.2.0.1.0 - Production on Sat Jun 20 23:34:27 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: Export.CTL
Data File: export.txt
Bad File: export.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table PHONE, loaded from every logical record.
Insert option in effect for this table: INSERT
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
MAC FIRST * , CHARACTER
DESCRIPTIONS NEXT * , CHARACTER
EXTENTION NEXT * , CHARACTER
Record 41: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 149: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 169: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 170: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 177: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 179: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 185: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 186: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 187: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 189: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 190: Rejected - Error on table PHONE, column EXTENTION.
Column not found before end of logical record (use TRAILING NULLCOLS)
Table PHONE:
182 Rows successfully loaded.
11 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.
Space allocated for bind array: 49536 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 193
Total logical records rejected: 11
Total logical records discarded: 0
Run began on Sat Jun 20 23:34:27 2009
Run ended on Sat Jun 20 23:34:27 2009
Elapsed time was: 00:00:00.23
CPU time was: 00:00:00.04