达梦数据库迁移数据报错 字符串截断

达梦数据库迁移数据报错 字符串截断

merge into demployee t
using(
select id,name,address from xxx_temp.demployee ) tt
on (t.id = tt.id)
when not matched then
insert(id,name,address) values
(tt.id,tt.name,tt.address);

address字符串字段长度不一致的问题,现在的库是varchar2(100),xxx_temp.demployee的库是varchar2(150),字段长度调整成一致即可