1 2 Previous Next 17 Replies Latest reply: Aug 12, 2013 12:11 PM by Deep2910 Branched from an earlier discussion. RSS

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

    Deep2910

      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