Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01438: value larger than specified precision allows for this column

593270Nov 27 2007 — edited Mar 22 2010
Hi,

Can anybody help..
Created the target table same structure as the source table.Script for the target table is

create table TRG_MTL_SYSTEM
as select *
from MTL_SYSTEM_ITEMS_B.... and I Successfully reversed the source table and target tables into the models. Created one interface for those target and source tables and mapped columns through auto mapping. When i am executing the interface to load the data to the target , I am getting these error "ORA-01438: value larger than specified precision allows for this column" while executing the interface.

Can anybody suggest me the solution where i did the mistake..

Thanks in Adavance............
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2010
Added on Nov 27 2007
#business-intelligence-applications, #data-integrator, #system-management-and-integration
16 comments
22,959 views