I suppose Theere is Data length Problem.
Either the Destination column length to be increased or the Value need to be truncated before insert.

If Altering table is no Problem issue this in Production

Alter table tabname
Modify(columnnname varchar2(specify the length 250));

Should be fine... Otherwise in Insert statement use
Insert into tabname1
select c1, c2, c3, Substr(c4,1,190), c5 etc... from Tbname2.

The Column that is having Length Problem, in insert use Substr...
Hoep this will help.
Thanks