Upgrading The Columns ERROR: ORA-01441: Cannot Decrease Column Length Because Some Value Is Too Big
(Doc ID 2551208.1)
Last updated on SEPTEMBER 13, 2023
Applies to:
Oracle Utilities Meter Data Management - Version 2.1.0.2 and laterInformation in this document applies to any platform.
Goal
On : 2.1.0.2 version, Environment
Customer trying to upgrade MDM from V2.1.0.2.0 to V2.1.0.3.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
CI_ALG_TYPE_PRM_L
(
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
)
Solution
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
| Goal |
| Solution |
| References |