My Oracle Support Banner

Randomly hitting "ORA-22814: attribute or element value is larger than specified in type" (Doc ID 2600614.1)

Last updated on NOVEMBER 23, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


On : version,

Question about Database behavior after characterset conversion

Our Development environment was setup in MuliByte character set (AL32UTF8), we are in the process of converting our test and PROD environment to Multibyte from WE8MSWIN1252 .
In the process today, we hit an issue, where some objects we have created in the test environment (single byte characters) with creation scripts as multi byte character set (for example Name varchar2(50 char)), these objects did not work after the conversion, getting error attribute or element value is larger than specified in type"

When we dropped and recreated it worked. Is there any chance you can assist us with a script to identify which objects are created with explicit multi byte in the Database?




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

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