SQL*Loader: Release 10.2.0.1.0 - Production on Fri Jan 5 16:29:00 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: C:\MFloat\intransit\control.CTL Data File: C:\MFloat\intransit\test.txt Bad File: C:\MFloat\intransit\BAD.TXT 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 JAZZ_UNSOLD_INTRANSIT_TMP, loaded from every logical record. Insert option in effect for this table: INSERT TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- MOBILENO FIRST * | O(") CHARACTER ISSUANCEDATE NEXT * | O(") CHARACTER REGION_DMP NEXT * | O(") CHARACTER LOCATION_TYPE NEXT * | O(") CHARACTER PACKAGEPLANCODE NEXT * | O(") CHARACTER LOCATIONFROM NEXT * | O(") CHARACTER LOCATIONTO NEXT * | O(") CHARACTER Table JAZZ_UNSOLD_INTRANSIT_TMP: 17 Rows 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. Space allocated for bind array: 115584 bytes(64 rows) Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records read: 17 Total logical records rejected: 0 Total logical records discarded: 0 Run began on Fri Jan 05 16:29:00 2007 Run ended on Fri Jan 05 16:29:03 2007 Elapsed time was: 00:00:03.48 CPU time was: 00:00:00.11