SQL*Loader: Release 11.2.0.3.0 - Production on Thu Jun 12 21:25:28 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Control File: TEST_SQLLDR.ctl Data File: TEST_SQLLDR.csv Bad File: TEST_SQLLDR.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: 7:7 != 0X2c(character ','), in next physical record Preserving continuation characters as data Path used: Conventional Table TEST_SQLLDR, 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 ------------------------------ ---------- ----- ---- ---- --------------------- ID FIRST * ^ O(") CHARACTER NAME NEXT * ^ O(") CHARACTER NUM NEXT * ^ O(") CHARACTER Record 1: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 44, maximum: 10) Record 2: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 56, maximum: 10) Record 3: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 44, maximum: 10) Record 4: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 56, maximum: 10) Record 5: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 44, maximum: 10) Record 6: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 56, maximum: 10) Record 7: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 44, maximum: 10) Record 8: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 56, maximum: 10) Record 9: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 44, maximum: 10) Record 10: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 56, maximum: 10) Record 11: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 44, maximum: 10) Record 12: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 56, maximum: 10) Table TEST_SQLLDR: 0 Rows successfully loaded. 12 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: 12 Total logical records rejected: 12 Total logical records discarded: 0 Run began on Thu Jun 12 21:25:28 2014 Run ended on Thu Jun 12 21:25:29 2014 Elapsed time was: 00:00:01.53 CPU time was: 00:00:00.02