Oracle 9i Windows 2003
(SQL Loader )
I m lading data into oracle table
giving the error
commit point reached , logical record count 64
Table DAILYPRICE, 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
------------------------------ ---------- ----- ---- ---- ---------------------
DP_CODE FIRST * , CHARACTER
CODE NEXT * , CHARACTER
DP_FND_CODE NEXT * , CHARACTER
DP_FND_NAME NEXT * , CHARACTER
DP_CO_CODE NEXT * , CHARACTER
DP_CO_NAME NEXT * , CHARACTER
DP_UPRICE NEXT * , CHARACTER
DP_DATE NEXT * , CHARACTER
Record 1: Rejected - Error on table DAILYPRICE, column DP_UPRICE.
ORA-01722: invalid number
Record 2: Rejected - Error on table DAILYPRICE, column DP_UPRICE.
ORA-01722: invalid number
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table DAILYPRICE:
0 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: 132096 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 64
Total logical records rejected: 51
Total logical records discarded: 0
Run began on Tue Apr 20 16:56:16 2010
Run ended on Tue Apr 20 16:56:16 2010
Elapsed time was: 00:00:00.17
CPU time was: 00:00:00.03