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 : 29-06-2017
ORA-24190

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

  • ora-40103 : invalid case-id column: string
  • ora-29866 : cannot create domain index on a column of index-organized table
  • ora-37113 : OLAP API initialization error: (string)
  • ora-13195 : failed to generate maximum tile value
  • ora-38401 : synonym string not allowed
  • ora-29265 : HTTP header not found
  • ora-31229 : DBMS_LDAP: invalid input parameter
  • ora-12425 : cannot apply policies or set authorizations for system schemas
  • ora-00450 : background process 'string' did not start
  • ora-09799 : File label retrieval failed.
  • ora-06107 : NETTCP: ORACLE network server not found
  • ora-09838 : removeCallback: failure removing the callback port.
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-37008 : (AWLISTALL06) number writers
  • ora-30378 : MV_CAPABILITIES_TABLE is not compatible with Oracle version
  • ora-32733 : Error occurred when executing Parallel Oradebug
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-01143 : cannot disable media recovery - file string needs media recovery
  • ora-15186 : ASMLIB error function = [string], error = [string], mesg = [string]
  • ora-06805 : TLI Driver: could not send datagram SAP packet for SPX
  • ora-13198 : Spatial error: string
  • ora-16540 : invalid argument
  • ora-24905 : invalid recepient protocol attribute passed into OCI call
  • ora-12819 : missing options in PARALLEL clause
  • ora-14700 : Object(s) owned by SYS cannot be locked by non-SYS user
  • ora-23347 : datatype string for column string table string not supported
  • ora-16021 : session string destination cannot be the same as session string destination
  • ora-09319 : slgtd: unable to obtain the current date and time
  • ora-12615 : TNS:preempt error
  • 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.