Upgrading The Columns ERROR: ORA-01441: Cannot Decrease Column Length Because Some Value Is Too Big
(Doc ID 2551208.1)
Last updated on JULY 05, 2021
Applies to:Oracle Utilities Meter Data Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
On : 184.108.40.206 version, Environment
Customer trying to upgrade MDM from V220.127.116.11.0 to V18.104.22.168.0 and I get the following error
Upgrading the columns
ERROR: ORA-01441: cannot decrease column length because some value is too big (DBD ERROR: error possibly near <*> indicator at char 37 in 'ALTER TABLE CI_ALG_TYPE_PRM_L MODIFY <*>ALG_PARM_LBL VARCHAR2 (100)') occured while executing ALTER TABLE CI_ALG_TYPE_PRM_L MODIFY ALG_PARM_LBL VARCHAR2 (100)
Error Occured, Process being aborted
the table at the moment looks this
ALG_TYPE_CD CHAR(12 BYTE) NOT NULL,
SEQNO NUMBER(5) NOT NULL,
LANGUAGE_CD CHAR(3 BYTE) NOT NULL,
ALG_PARM_LBL VARCHAR2(4000 BYTE) DEFAULT ' ' NOT NULL,
VERSION NUMBER(5) DEFAULT 1 NOT NULL,
OWNER_FLG CHAR(4 BYTE) DEFAULT ' ' NOT NULL
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document