ORA-01439:要更改数据类型,则要修改的列必须为空

alter table materials rename column SPECS to mySPECS;
alter table materials add SPECS VARCHAR2(1024);
update materials set SPECS = mySPECS;
alter table materials drop column mySPECS;