插入数据长度大于4000，报该错ORA-01461 解决方案 原创

-- 插入数据长度大于4000，报该错ORA-01461 解决方案

-- 备份数据
create table CFB_SAP_VOUCHER_TEMP221227 as select * from CFB_SAP_VOUCHER_TEMP;
-- 1添加一个clob字段
alter table CFB_SAP_VOUCHER_TEMP add CONTRACT_ARG_MEMO_TMP clob;
-- 2原字段值拷贝到新字段
update CFB_SAP_VOUCHER_TEMP set CONTRACT_ARG_MEMO_TMP = CONTRACT_ARG_MEMO;
-- 3删除原来字段
alter table CFB_SAP_VOUCHER_TEMP drop column CONTRACT_ARG_MEMO;
-- 4新建的clob字段名称修改为原名称
alter table CFB_SAP_VOUCHER_TEMP rename column CONTRACT_ARG_MEMO_TMP to CONTRACT_ARG_MEMO;