SQL> alter table TRIG_SQL_2 modify sqltext blob;
alter table TRIG_SQL_2 modify sqltext blob
*
ERROR at line 1:
ORA-22858: invalid alteration of datatype
alter table TRIG_SQL_2 modify sqltext blob
*
ERROR at line 1:
ORA-22858: invalid alteration of datatype
SQL>
解决办法,重建表,用clob字段。