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_number | varchar2(10 byte) | y | | |
| id_number | varchar2(10 byte) | y | | |
| assigned_memb_number | varchar2(15 byte) | y | | |
| assoc_amt | number(14,2) | y | | |
| assoc_type | char(1 byte) | y | | |
| date_added | date | y | | |
| date_modified | date | y | | |
| operator_name | varchar2(32 byte) | y | | |
| user_group | varchar2(2 byte) | y | | |
| location_id | number | y | | |
Can you please tell me why the sqlldr is throwing error?The data seems correct to me.