ORA-24502: codepoint length overflows

Cause : Returned buffer has more codepoints than allowed

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Set OCI_MAXCHAR_SIZE large enough to accommodate

update : 28-05-2017

ORA-24502 - codepoint length overflows
ORA-24502 - codepoint length overflows

  • ora-25448 : rule string.string has errors
  • ora-13914 : Threshold notification failed.
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-01506 : missing or illegal database name
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-02707 : osnacx: cannot allocate context area
  • ora-22309 : attribute with name "string" already exists
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-16825 : Fast-Start Failover and other errors or warnings detected for the database
  • ora-29541 : class string.string could not be resolved
  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-38421 : attribute string already exists
  • ora-12984 : cannot drop partitioning column
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-30191 : missing argument list
  • ora-13148 : failed to generate SQL filter
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-13460 : GeoRaster metadata SRS error
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-38903 : DML error logging is not supported for abstract column "string"
  • ora-30980 : Invalid Input.
  • ora-08007 : Further changes to this block by this transaction not allowed
  • ora-28518 : data dictionary translation has illegal translation type
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-30503 : system triggers cannot have a REFERENCING clause
  • ora-19594 : control file already included as string
  • ora-27077 : too many files open
  • ora-02371 : Loader must be at least version string.string.string.string.string for direct path
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.