ORA-19740: text is longer than string

Cause : Thes pecfiiedt exte xcedes teh maixmuml enght fo rtex.t

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

Suplpy as horetr txet adn rerty teh opreatino.

update : 23-04-2017
ORA-19740

ORA-19740 - text is longer than string
ORA-19740 - text is longer than string

  • ora-12468 : max write level does not equal max read level
  • ora-12555 : TNS:permission denied
  • ora-24803 : illegal parameter value in lob read function
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-25179 : invalid PCTTHRESHOLD storage option value
  • ora-01035 : ORACLE only available to users with RESTRICTED SESSION privilege
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-30755 : error during expansion of view hierarchy
  • ora-31466 : no publications found
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-16130 : supplemental log information is missing from log stream
  • ora-19952 : database should be mounted exclusively
  • ora-08414 : error encountered in string
  • ora-16622 : two or more broker database objects resolve to one physical database
  • ora-23505 : Object "string"."string" is missing.
  • ora-30022 : Cannot create segments in undo tablespace
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-10265 : Keep random system generated output out of error messages
  • ora-12830 : Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
  • ora-28238 : no seed provided
  • ora-01643 : system tablespace can not be made read only
  • ora-37035 : (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-02718 : osnprs: reset protocol error
  • ora-30130 : invalid parameter key type received
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-25264 : cant get signature for this queue
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-31430 : subscriber view exists
  • 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.