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 OCTOBER 23, 2019

Applies to:

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

Symptoms

On : 12.1.0.2 version,

ACTUAL BEHAVIOR
---------------
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?

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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