SQL*Loader: Release 8.0.5.1.0 - Production on Wed Nov 8 16:6:12 2000 (c) Copyright 1998 Oracle Corporation. All rights reserved. Control File: ctrlfile.ctl Data File: list.dat Bad File: list.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 65536 bytes Continuation: none specified Path used: Conventional Table PHONELIST, loaded from every logical record. Insert option in effect for this table: APPEND Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- PHOTO FIRST * | O(") CHARACTER NAME NEXT * | O(") CHARACTER EXT NEXT * | O(") CHARACTER DIRECT NEXT * | O(") CHARACTER CELL NEXT * | O(") CHARACTER EMAIL NEXT * | O(") CHARACTER TITLE NEXT * WHT O(") CHARACTER Record 86: Rejected - Error on table PHONELIST, column NAME. Column not found before end of logical record (use TRAILING NULLCOLS) Record 87: Rejected - Error on table PHONELIST, column NAME. Column not found before end of logical record (use TRAILING NULLCOLS) Record 88: Rejected - Error on table PHONELIST, column NAME. Column not found before end of logical record (use TRAILING NULLCOLS) Record 89: Rejected - Error on table PHONELIST, column NAME. Column not found before end of logical record (use TRAILING NULLCOLS) Table PHONELIST: 85 Rows successfully loaded. 4 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: 65016 bytes(36 rows) Space allocated for memory besides bind array: 0 bytes Total logical records skipped: 0 Total logical records read: 89 Total logical records rejected: 4 Total logical records discarded: 0 Run began on Wed Nov 08 16:06:12 2000 Run ended on Wed Nov 08 16:06:13 2000 Elapsed time was: 00:00:00.29 CPU time was: 00:00:00.04