SQL*Loader: Release 10.2.0.3.0 - Production on Thu Dec 27 00:00:18 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: ../ctl_files/performance.ctl Data File: webperf.csv Bad File: ../ctl_files/webperf.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: none specified Path used: Conventional Table PERFCORE3, loaded from every logical record. Insert option in effect for this table: APPEND TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- CLIENTID FIRST * , O(") CHARACTER CODE NEXT * , O(") CHARACTER SQL string for column : "translate(:code, '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'ZYXWUVUTSRQPONMLKJIHGFEDCBA9876543210')" ASSETCLASSCODE NEXT * , O(") CHARACTER BEGINDATE NEXT * , O(") DATE MM/DD/YYYY ENDDATE NEXT * , O(") DATE MM/DD/YYYY RETURNAFTERFEETWR NEXT * , O(") CHARACTER RETURNAFTERFEEIRR NEXT * , O(") CHARACTER RETURNBEFOREFEETWR NEXT * , O(") CHARACTER RETURNBEFOREFEEIRR NEXT * , O(") CHARACTER AFTERFEEIDENTIFERTWR NEXT * , O(") DATE MM/DD/YYYY BEFOREFEEIDENTIFERTWR NEXT * , O(") DATE MM/DD/YYYY PROCESSED CONSTANT Value is 'N' PROCESSED CONSTANT Value is 'N' ID__ NEXT * , O(") CHARACTER SQL string for column : "db_seq_PERF.nextval" Record 1: Rejected - Error on table PERFCORE3, column CLIENTID. ORA-12899: value too large for column "PMRDEV"."PERFCORE3"."CLIENTID" (actual: 11, maximum: 8) Record 829: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 1142: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 1143: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 1146: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 1873: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 1898: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 8577: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 9328: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 9596: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 10128: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 13723: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 14868: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 17132: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 18893: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 20296: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 21628: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 22213: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 23463: Rejected - Error on table PERFCORE3, column RETURNAFTERFEETWR. ORA-01438: value larger than specified precision allowed for this column Record 23922: Rejected - Error on table PERFCORE3, column RETURNAFTERFEEIRR. ORA-01438: value larger than specified precision allowed for this column Table PERFCORE3: 23941 Rows successfully loaded. 20 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: 198272 bytes(64 rows) Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records read: 23961 Total logical records skipped: 0 Total logical records read: 23961 Total logical records rejected: 20 Total logical records discarded: 0 Run began on Thu Dec 27 00:00:18 2007 Run ended on Thu Dec 27 00:00:21 2007 Elapsed time was: 00:00:02.93 CPU time was: 00:00:00.31