SQL*Loader: Release 9.2.0.1.0 - Production on Thu Nov 13 15:02:56 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Control File: E:\Share\IFACE\iface.ctl Data File: E:\Share\IFACE\ifaceMad.txt Bad File: E:\Share\IFACE\bad.txt Discard File: E:\Share\IFACE\discard.txt (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Continuation: none specified Path used: Direct Table GWCIF_TMP, loaded when 1:1 = 0X44(character 'D') Insert option in effect for this table: TRUNCATE Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- TYPE 1:1 1 CHARACTER SQL string for column : "TRIM(:TYPE)" ACCOUNTNO 2:12 11 CHARACTER SQL string for column : "TRIM(:ACCOUNTNO)" SHORTNAME 328:437 110 CHARACTER SQL string for column : "TRIM(:SHORTNAME)" BOOKBALSIGN 38:38 1 CHARACTER SQL string for column : "TRIM(:BOOKBALSIGN)" BOOKBAL 39:51 13 CHARACTER SQL string for column : "TRIM(:BOOKBAL)" CLEARBALSIGN 52:52 1 CHARACTER SQL string for column : "TRIM(:CLEARBALSIGN)" CLEARBAL 53:65 13 CHARACTER SQL string for column : "TRIM(:CLEARBAL)" ODLIMIT 66:76 11 CHARACTER SQL string for column : "TRIM(:ODLIMIT)" ARMTYPE 77:78 2 CHARACTER SQL string for column : "TRIM(:ARMTYPE)" CRACCINTCTDSGN 79:79 1 CHARACTER SQL string for column : "TRIM(:CRACCINTCTDSGN)" CRACCINTCTD 80:92 13 CHARACTER SQL string for column : "TRIM(:CRACCINTCTD)" DRACCINTCTDSGN 93:93 1 CHARACTER SQL string for column : "TRIM(:DRACCINTCTDSGN)" DRACCINTCTD 94:106 13 CHARACTER SQL string for column : "TRIM(:DRACCINTCTD)" ODLMTSTARTDT 107:113 7 CHARACTER SQL string for column : "TRIM(:ODLMTSTARTDT)" ODLMTENDDT 114:120 7 CHARACTER SQL string for column : "TRIM(:ODLMTENDDT)" LASTTXNDT 121:127 7 CHARACTER SQL string for column : "TRIM(:LASTTXNDT)" CUSTIDTYPE 128:129 2 CHARACTER SQL string for column : "TRIM(:CUSTIDTYPE)" CUSTID 130:145 16 CHARACTER SQL string for column : "TRIM(:CUSTID)" INTRATESGN 146:146 1 CHARACTER SQL string for column : "TRIM(:INTRATESGN)" INTRATE 147:154 8 CHARACTER SQL string for column : "TRIM(:INTRATE)" FDSTARTDT 155:161 7 CHARACTER SQL string for column : "TRIM(:FDSTARTDT)" FDMATDT 162:168 7 CHARACTER SQL string for column : "TRIM(:FDMATDT)" FDTERMCD 169:169 1 CHARACTER SQL string for column : "TRIM(:FDTERMCD)" PRODTYPE 170:170 1 CHARACTER SQL string for column : "TRIM(:PRODTYPE)" STAFFIND 171:173 3 CHARACTER SQL string for column : "TRIM(:STAFFIND)" RESCODE 174:175 2 CHARACTER SQL string for column : "TRIM(:RESCODE)" ACCOUNTSTAT 176:177 2 CHARACTER SQL string for column : "TRIM(:ACCOUNTSTAT)" CURRCODE 178:180 3 CHARACTER SQL string for column : "TRIM(:CURRCODE)" CUSTRELCODE 181:183 3 CHARACTER SQL string for column : "TRIM(:CUSTRELCODE)" FUNDSOWN 184:185 2 CHARACTER SQL string for column : "TRIM(:FUNDSOWN)" YTDINTPAIDSGN 186:186 1 CHARACTER SQL string for column : "TRIM(:YTDINTPAIDSGN)" YTDINTPAID 187:199 13 CHARACTER SQL string for column : "TRIM(:YTDINTPAID)" OPENDT 200:206 7 CHARACTER SQL string for column : "TRIM(:OPENDT)" CSICODE 207:210 4 CHARACTER SQL string for column : "TRIM(:CSICODE)" ARMCODE 211:215 5 CHARACTER SQL string for column : "TRIM(:ARMCODE)" ODCLASS 782:785 4 CHARACTER SQL string for column : "TRIM(:ODCLASS)" FDTERM 786:789 4 CHARACTER SQL string for column : "TRIM(:FDTERM)" SUBPRODUCT 790:793 4 CHARACTER SQL string for column : "TRIM(:SUBPRODUCT)" Record 1: Discarded - failed all WHEN clauses. Record 17904: Rejected - Error on table GWCIF_TMP. ORA-03113: end-of-file on communication channel SQL*Loader-926: OCI error while uldlfca:OCIDirPathColArrayLoadStream for table GWCIF_TMP SQL*Loader-2026: the load was aborted because SQL Loader cannot continue. SQL*Loader-925: Error while uldlgs: OCIStmtExecute (ptc_hp) ORA-03114: not connected to ORACLE SQL*Loader-925: Error while uldlgs: OCIStmtFetch (ptc_hp) ORA-24338: statement handle not executed Table GWCIF_TMP: 0 Rows successfully loaded. 1 Row not loaded due to data errors. 1 Row not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Bind array size not used in direct path. Column array rows : 5000 Stream buffer bytes: 256000 Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records read: 19181 Total logical records rejected: 1 Total logical records discarded: 1 Total stream buffers loaded by SQL*Loader main thread: 15 Total stream buffers loaded by SQL*Loader load thread: 15 Run began on Thu Nov 13 15:02:56 2008 Run ended on Thu Nov 13 15:03:16 2008 Elapsed time was: 00:00:19.37 CPU time was: 00:00:00.95