This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Aug 12, 2013 10:11 AM by Deep2910 Branched from an earlier discussion. RSS

Re: Sql*loader 11g - Error ORA-12899

Deep2910 Newbie
Currently Being Moderated

My Bad file has first 2 records like this:

MEMB_NUMBER,ID_NUMBER,ASSIGNED_MEMB_NUMBER,ASSOC_AMT,ASSOC_TYPE,DATE_ADDED,DATE_MODIFIED,OPERATOR_NAME,USER_GROUP,LOCATION_ID,
0000000107,0000828633, ,1.5,J,22-FEB-02,12-JUN-02,MSUM080_MEMB_CONV,00,,
0000002301,0000800007, ,297.5,J,03-AUG-00,12-JUN-02,MSUM080_MEMB_CONV,00,,

My Log file says:

Record 1: Rejected - Error on table OWBREP.MEMB_ENTITY, column ID_NUMBER.
ORA-12899: value too large for column "OWBREP"."MEMB_ENTITY"."ID_NUMBER" (actual: 20, maximum: 10)

Record 2: Rejected - Error on table OWBREP.MEMB_ENTITY, column ASSOC_AMT.
ORA-01722: invalid number


Decription of target table:


memb_numbervarchar2(10 byte)y
id_numbervarchar2(10 byte)y
assigned_memb_numbervarchar2(15 byte)y
assoc_amtnumber(14,2)y
assoc_typechar(1 byte)y
date_addeddatey
date_modifieddatey
operator_namevarchar2(32 byte)y
user_groupvarchar2(2 byte)y
location_idnumbery


Can you please tell me why the sqlldr is throwing error?The data seems correct to me.

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points