EAS安装补丁执行脚本时提示“ORA-01441: cannot decrease column...
王秀珩
1,392次浏览
编辑于2018年07月23日 17:39:47
适用版本通用
问题描述安装SP1补丁PTM066366时，执行脚本时报错：SELECT COUNT(*) FCOUNT INTO CNT FROMUSER_TAB_COLUMNS WHERE (COLUMN_NAME = 'FRESUME' AND TABLE_NAME ='T_SHE_CHEQUE');IF CNT > 0 THENEXECUTE IMMEDIATE 'ALTER TABLEt_she_cheque MODIFY FResume NVARCHAR2 (300)';END IF;END;] failed, sqlcode[1441] sqlstat[72000],Causedby[ORA-01441: cannot decrease columnlength because some value is too big
问题描述安装SP1补丁PTM066366时，执行脚本时报错：SELECT COUNT(*) FCOUNT INTO CNT FROMUSER_TAB_COLUMNS WHERE (COLUMN_NAME = 'FRESUME' AND TABLE_NAME ='T_SHE_CHEQUE');IF CNT > 0 THENEXECUTE IMMEDIATE 'ALTER TABLEt_she_cheque MODIFY FResume NVARCHAR2 (300)';END IF;END;] failed, sqlcode[1441] sqlstat[72000],Causedby[ORA-01441: cannot decrease columnlength because some value is too big
推荐阅读