update b set text2 = substr(text2,1,255);

然后alter table将列的长度设置为255:

then alter table to set length of column to 255 :

alter table b MODIFY "TEXT2" varchar2(255 byte);