SQL Language (MOSC)

MOSC Banner

decrease column size

edited Apr 15, 2015 6:07AM in SQL Language (MOSC) 2 commentsAnswered ✓

Hi,

     I tried decrease column size from varchar2(3000) to varchar2(1000), but got error: Failed to commit: ORA-01441: cannot decrease column length because some value is too big.

    

     But maxdatalength is 997: select max(length(kuvaus)) as max_length from paikkatietotuote;

                                            MAX_LENGTH

                                                  997

   So there is no data over 997 - why error when decrease column? And how to resolve problem?

Regards Jari

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center