将varchar字段修改为clob字段

--BPM_VARIABLE    
alter table   BPM_VARIABLE     add newColumn clob;
update  BPM_VARIABLE     set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE     drop column STRING_VALUE_;
alter table   BPM_VARIABLE     rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT1 
alter table   BPM_VARIABLE_EXT1  add newColumn clob;
update  BPM_VARIABLE_EXT1  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT1  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT1  rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT2 
alter table   BPM_VARIABLE_EXT2  add newColumn clob;
update  BPM_VARIABLE_EXT2  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT2  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT2  rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT3 
alter table   BPM_VARIABLE_EXT3  add newColumn clob;
update  BPM_VARIABLE_EXT3  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT3  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT3  rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT4 
alter table   BPM_VARIABLE_EXT4  add newColumn clob;
update  BPM_VARIABLE_EXT4  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT4  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT4  rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT5 
alter table   BPM_VARIABLE_EXT5  add newColumn clob;
update  BPM_VARIABLE_EXT5  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT5  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT5  rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT6 
alter table   BPM_VARIABLE_EXT6  add newColumn clob;
update  BPM_VARIABLE_EXT6  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT6  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT6  rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT7 
alter table   BPM_VARIABLE_EXT7  add newColumn clob;
update  BPM_VARIABLE_EXT7  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT7  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT7  rename column newColumn to STRING_VALUE_;
--BPM_VARIABLE_EXT8 
alter table   BPM_VARIABLE_EXT8  add newColumn clob;
update  BPM_VARIABLE_EXT8  set newColumn=STRING_VALUE_ where STRING_VALUE_ is not null;
commit;     
alter table   BPM_VARIABLE_EXT8  drop column STRING_VALUE_;
alter table   BPM_VARIABLE_EXT8  rename column newColumn to STRING_VALUE_;
--修改完列后，重建索引
--BPM_VARIABLE
alter index   IDX_VAR_EXECUTION rebuild;
alter index   IDX_VAR_EXESYS  rebuild;
alter index   IDX_VAR_LOB rebuild;
alter index   IDX_VAR_TASK  rebuild;
alter index   SYS_C0031259  rebuild;
--BPM_VARIABLE_EXT1
alter index   IDX_VAR_EXECUTION_EXT1  rebuild;
alter index   IDX_VAR_EXESYS_EXT1 rebuild;
alter index   IDX_VAR_LOB_EXT1  rebuild;
alter index   IDX_VAR_TASK_EXT1 rebuild;
alter index   SYS_C0031260  rebuild;
--BPM_VARIABLE_EXT2
alter index   IDX_VAR_EXECUTION_EXT2  rebuild;
alter index   IDX_VAR_EXESYS_EXT2 rebuild;
alter index   IDX_VAR_LOB_EXT2  rebuild;
alter index   IDX_VAR_TASK_EXT2 rebuild;
alter index   SYS_C0031261  rebuild;
--BPM_VARIABLE_EXT3
alter index   IDX_VAR_EXECUTION_EXT3  rebuild;
alter index   IDX_VAR_EXESYS_EXT3 rebuild;
alter index   IDX_VAR_LOB_EXT3  rebuild;
alter index   IDX_VAR_TASK_EXT3 rebuild;
alter index   SYS_C0031262  rebuild;
--BPM_VARIABLE_EXT4
alter index   IDX_VAR_EXECUTION_EXT4  rebuild;
alter index   IDX_VAR_EXESYS_EXT4 rebuild;
alter index   IDX_VAR_LOB_EXT4  rebuild;
alter index   IDX_VAR_TASK_EXT4 rebuild;
alter index   SYS_C0031263  rebuild;
--BPM_VARIABLE_EXT5
alter index   IDX_VAR_EXECUTION_EXT5  rebuild;
alter index   IDX_VAR_EXESYS_EXT5 rebuild;
alter index   IDX_VAR_LOB_EXT5  rebuild;
alter index   IDX_VAR_TASK_EXT5 rebuild;
alter index   SYS_C0031264  rebuild;
--BPM_VARIABLE_EXT6
alter index   IDX_VAR_EXECUTION_EXT6  rebuild;
alter index   IDX_VAR_EXESYS_EXT6 rebuild;
alter index   IDX_VAR_LOB_EXT6  rebuild;
alter index   IDX_VAR_TASK_EXT6 rebuild;
alter index   SYS_C0031265  rebuild;
--BPM_VARIABLE_EXT7
alter index   IDX_VAR_EXECUTION_EXT7  rebuild;
alter index   IDX_VAR_EXESYS_EXT7 rebuild;
alter index   IDX_VAR_LOB_EXT7  rebuild;
alter index   IDX_VAR_TASK_EXT7 rebuild;
alter index   SYS_C0031266  rebuild;
--BPM_VARIABLE_EXT8
alter index   IDX_VAR_EXECUTION_EXT8  rebuild;
alter index   IDX_VAR_EXESYS_EXT8 rebuild;
alter index   IDX_VAR_LOB_EXT8  rebuild;
alter index   IDX_VAR_TASK_EXT8 rebuild;
alter index   SYS_C0031267  rebuild;