decrease column size

[mageri]

create table x as select * from y;

truncate table y;

alter table x modify c1 number(10);

insert into x select * from y;