ORA-12899: value too large for column "TGT_SCHEMA"."CUSTOMERS"."ZIPCODE"
Posted on 2013-05-11
When trying to load data using following sql from source to target, I get the following error:
insert into tgt_schema.customer_tab
ERROR at line 3:
ORA-12899: value too large for column "TGT_SCHEMA"."CUSTOMER_TAB"."ZIPCODE"
(actual: 16, maximum: 10)
I altered the column data type in the target schema and changed the precision of zipcode to varchar2(32) and executed the above sql and the query ram fine.
Now I have to questions:
1. How to find the record in the source which exceeded varchar2(10)
2. How did the source contained this value when the precision in the source table is also varchar2(10)?
Please advise.. please let me know if you need any other information