My Oracle Support Banner

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 2.1.0.2 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.