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 : 23-09-2017
ORA-24502

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

  • ora-14262 : new subpartition name must differ from the old subpartition name
  • ora-24059 : invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
  • ora-26754 : cannot specify both one-to-one transformation function string and one-to-many transformation function string
  • ora-04063 : %s has errors
  • ora-19579 : archivelog record for string not found
  • ora-38740 : Usable blocks value string is not valid.
  • ora-26564 : %s argument is not of specified type
  • ora-27012 : skgfrd: read from file failed
  • ora-02722 : osnpui: cannot send break message to orapop
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-38790 : BEFORE must be specified with RESETLOGS
  • ora-30188 : reserved for future use
  • ora-19564 : error occurred writing string bytes at block number string
  • ora-01948 : identifier's name length (string) exceeds maximum (string)
  • ora-14126 : only a may follow description(s) of resulting partitions
  • ora-27144 : attempt to kill process failed
  • ora-31121 : The string operator can not be FALSE
  • ora-01774 : Dump undo option specified more than once
  • ora-08116 : can not acquire dml enough lock(S mode) for online index build
  • ora-00300 : illegal redo log block size string specified - exceeds limit of string
  • ora-14251 : Specified subpartition does not exist
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-16529 : bad sender id
  • ora-28366 : invalid database encryption operation
  • ora-37138 : (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
  • ora-31642 : the following SQL statement fails: string
  • ora-19563 : %s header validation failed for file string
  • ora-12236 : TNS:protocol support not loaded
  • ora-02160 : index-organized table can not contain columns of type LONG
  • ora-29831 : operator binding not found
  • 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.