解决ORACLE的VARCHAR2字段大于4000问题

oracle中VARCHAR2字段最大4000，索引要更改字段长为CBLOB,oracle不允许直接改VARCHAR2为CBLOB，所以如下解决：
怎么解决
1）先备份

CREATE TABLE TB_COMMAND_TASK_BAK as SELECT * FROM TB_COMMAND_TASK

添加字段
alter table TR_TASK_PUBLISH add ECHO_CONTEXT1 CLOB;
comment on column TR_TASK_PUBLISH.ECHO_CONTEXT is '页面回显数据';
添加数据
UPDATE TR_TASK_PUBLISH SET ECHO_CONTEXT1 = ECHO_CONTEXT WHERE 1=1;
修改字段
alter table TR_TASK_PUBLISH rename column ECHO_CONTEXT to ECHO_CONTEXT2;
修改
alter table TR_TASK_PUBLISH rename column ECHO_CONTEXT1 to ECHO_CONTEXT;
删除
alter table TR_TASK_PUBLISH drop column ECHO_CONTEXT2;