SQL*Loader: Release 11.2.0.3.0 - Production on Thu Jun 12 14:34:51 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: Concatenate every 3 physical records 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 NAME. second enclosure string not present Record 2: Rejected - Error on table TEST_SQLLDR, column ID. no terminator found after TERMINATED and ENCLOSED field Record 4: Rejected - Error on table TEST_SQLLDR, column NAME. second enclosure string not present Record 5: Rejected - Error on table TEST_SQLLDR, column ID. no terminator found after TERMINATED and ENCLOSED field Record 7: Rejected - Error on table TEST_SQLLDR, column NAME. second enclosure string not present Record 8: Rejected - Error on table TEST_SQLLDR, column ID. no terminator found after TERMINATED and ENCLOSED field Record 10: Rejected - Error on table TEST_SQLLDR, column NAME. second enclosure string not present Record 11: Rejected - Error on table TEST_SQLLDR, column ID. no terminator found after TERMINATED and ENCLOSED field Record 13: Rejected - Error on table TEST_SQLLDR, column NAME. second enclosure string not present Record 14: Rejected - Error on table TEST_SQLLDR, column ID. no terminator found after TERMINATED and ENCLOSED field Record 16: Rejected - Error on table TEST_SQLLDR, column NAME. second enclosure string not present Record 17: Rejected - Error on table TEST_SQLLDR, column ID. no terminator found after TERMINATED and ENCLOSED field Record 3: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 25, maximum: 10) Record 6: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 25, maximum: 10) Record 9: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 25, maximum: 10) Record 12: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 25, maximum: 10) Record 15: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 25, maximum: 10) Record 18: Rejected - Error on table TEST_SQLLDR, column ID. ORA-12899: value too large for column "CSMARTIRIS"."TEST_SQLLDR"."ID" (actual: 25, maximum: 10) Table TEST_SQLLDR: 0 Rows successfully loaded. 18 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: 18 Total logical records rejected: 18 Total logical records discarded: 0 Run began on Thu Jun 12 14:34:51 2014 Run ended on Thu Jun 12 14:34:52 2014 Elapsed time was: 00:00:01.09 CPU time was: 00:00:00.10