SQL*Loader: Release 10.2.0.1.0 - Production on Fri Jan 5 17:04:37 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 Record 1: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 14, maximum: 11) Record 2: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 3: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 4: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 5: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 6: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 7: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 8: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 9: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 10: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 11: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 12: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 13: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 14: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 15: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Record 16: Rejected - Error on table JAZZ_UNSOLD_INTRANSIT_TMP, column MOBILENO. ORA-12899: value too large for column "MFLOAT"."JAZZ_UNSOLD_INTRANSIT_TMP"."MOBILENO" (actual: 23, maximum: 11) Table JAZZ_UNSOLD_INTRANSIT_TMP: 0 Rows successfully loaded. 16 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: 16 Total logical records rejected: 16 Total logical records discarded: 0 Run began on Fri Jan 05 17:04:37 2007 Run ended on Fri Jan 05 17:04:37 2007 Elapsed time was: 00:00:00.45 CPU time was: 00:00:00.08