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;
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;