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 12.1.0.2 and laterInformation 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 |