SQL*Loader: Release 10.2.0.3.0 - Production on Fri Dec 28 01:05:50 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: ../ctl_files/positions.ctl Data File: webposn.csv Bad File: ../ctl_files/webposn.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 POSCORE3, 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 CUSTODIANID NEXT * , O(") CHARACTER ACCOUNTNO NEXT * , O(") CHARACTER SQL string for column : "translate(:accountNo, '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'ZYXWUVUTSRQPONMLKJIHGFEDCBA9876543210')" SECURITYTYPE NEXT * , O(") CHARACTER SYMBOL NEXT * , O(") CHARACTER CURRENCYCODE NEXT * , O(") CHARACTER ASOFDATE NEXT * , O(") DATE MM/DD/YYYY SHORTLONG NEXT * , O(") CHARACTER LOCALCLOSEPRICE NEXT * , O(") CHARACTER BASECCYCLOSEPRICE NEXT * , O(") CHARACTER ADJUNITCOST NEXT * , O(") CHARACTER UNADJUNITCOST NEXT * , O(") CHARACTER ADJBASEUNITCOST NEXT * , O(") CHARACTER UNADJLOCUNITCOST NEXT * , O(") CHARACTER ADJTRADETOTCOST NEXT * , O(") CHARACTER UNADJTRADETOTCOST NEXT * , O(") CHARACTER ADJBASETOTCOSTBASIS NEXT * , O(") CHARACTER UNADJBASETOTCOSTBASIS NEXT * , O(") CHARACTER PROJTRADECCYANNINC NEXT * , O(") CHARACTER REPBASECCYANNINC NEXT * , O(") CHARACTER LOCALMV NEXT * , O(") CHARACTER REPMV NEXT * , O(") CHARACTER ADJLOCALUGL NEXT * , O(") CHARACTER UNADJLOCALUGL NEXT * , O(") CHARACTER ADJREPUGL NEXT * , O(") CHARACTER UNADJREPUGL NEXT * , O(") CHARACTER LOCALACCINT NEXT * , O(") CHARACTER REPACCINT NEXT * , O(") CHARACTER REPCURRCODE NEXT * , O(") CHARACTER ADJSTLOCGL NEXT * , O(") CHARACTER STLOCGL NEXT * , O(") CHARACTER ADJLTLOCGL NEXT * , O(") CHARACTER LTLOCGL NEXT * , O(") CHARACTER ADJSTREPGL NEXT * , O(") CHARACTER STREPGL NEXT * , O(") CHARACTER ADJLTREPGL NEXT * , O(") CHARACTER LTREPGL NEXT * , O(") CHARACTER PROCESSED CONSTANT Value is 'N' ID__ NEXT * , O(") CHARACTER SQL string for column : "db_seq_position.nextval" value used for ROWS parameter changed from 64 to 25 Record 1: Rejected - Error on table POSCORE3, column CLIENTID. ORA-12899: value too large for column "PMRDEV"."POSCORE3"."CLIENTID" (actual: 9, maximum: 8) Record 2: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 3: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 4: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 5: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 6: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 7: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 8: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 9: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 10: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 11: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 12: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 13: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 14: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 15: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 16: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 17: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 18: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 19: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 20: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 21: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 22: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 23: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 24: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 25: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 26: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 27: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 28: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 29: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 30: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 31: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 34: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 35: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 37: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 40: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 41: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 42: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 43: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 44: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 45: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 46: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 47: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 48: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 49: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 50: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 51: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 52: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 53: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 54: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 55: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number Record 56: Rejected - Error on table POSCORE3, column LTREPGL. ORA-01722: invalid number MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run. Table POSCORE3: 5 Rows successfully loaded. 51 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: 251600 bytes(25 rows) Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records read: 75 Total logical records rejected: 51 Total logical records discarded: 0 Run began on Fri Dec 28 01:05:50 2007 Run ended on Fri Dec 28 01:05:50 2007 Elapsed time was: 00:00:00.25 CPU time was: 00:00:00.09