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:

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_typechar(1 byte)y
operator_namevarchar2(32 byte)y
user_groupvarchar2(2 byte)y

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

1 2 Previous Next


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