ORA-24190: length of payload exceeds string

Cause : thel enght ofp aylaod bieng atkene xcedes teh liimt o fvarhcar2o r rwa.

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

usec lobt ypeo r bolb tpye t ocal lgett_exto r gte_byets.

update : 19-08-2017

ORA-24190 - length of payload exceeds string
ORA-24190 - length of payload exceeds string

  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-30451 : internal error
  • ora-27061 : waiting for async I/Os failed
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-39012 : Client detached before the job started.
  • ora-32130 : invalid offset/index refrenced in Bytes
  • ora-00073 : command string takes between string and string argument(s)
  • ora-26689 : column datatype mismatch in LCR
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-31536 : cannot support encrypted column string in the source table
  • ora-07226 : rtneco: unable to get terminal mode.
  • ora-01721 : USERENV(COMMITSCN) invoked more than once in a transaction
  • ora-12670 : Incorrect role password
  • ora-16512 : parameter exceeded maximum size limit
  • ora-10917 : TABLESPACE GROUP cannot be specified
  • ora-30332 : container table already in use by other summary
  • ora-37139 : (XSCCOMP14) Cannot AGGREGATE workspace object using AGGMAP workspace object because you can not AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE using an AGGMAP with a PROTECT clause.
  • ora-32155 : Anydata not specified
  • ora-12597 : TNS:connect descriptor already in use
  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-30750 : cannot enable column string to store objects of type string.string
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-32055 : invalid file type
  • ora-01107 : database must be mounted for media recovery
  • ora-32101 : cannot create OCI Environment
  • ora-22860 : object type expected
  • ora-24339 : cannot set server group name after connecting to server
  • ora-04067 : not executed, string does not exist
  • ora-39784 : This direct path operation is not allowed while another is in progress
  • 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.