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 : 25-09-2017
ORA-19740

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

  • ora-25450 : error string during evaluation of rule set string.string
  • ora-12678 : Authentication disabled but required
  • ora-12819 : missing options in PARALLEL clause
  • ora-24900 : invalid or unsupported mode paramater passed in call
  • ora-22956 : The set contains no elements
  • ora-09271 : szlon: error verifying user name
  • ora-16212 : number processes specified for APPLY is too great
  • ora-24163 : dblink is not supported in rules engine DDLs
  • ora-32587 : Cannot drop nonexistent string supplemental logging
  • ora-27091 : unable to queue I/O
  • ora-23346 : primary key or object ID is undefined for table or materialized view string
  • ora-36155 : (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-01119 : error in creating database file 'string'
  • ora-14280 : all rows in table do not qualify for specified subpartition
  • ora-13431 : GeoRaster metadata rasterType error
  • ora-24853 : failed to connect thread to shared subsystem
  • ora-12669 : Shared server: outbound protocol does not support proxies
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-32345 : fail to refresh the materialized view string.string due to the changed synonym
  • ora-27086 : unable to lock file - already in use
  • ora-23291 : Only base table columns may be renamed
  • ora-09352 : Windows 32-bit Two-Task driver unable to spawn new ORACLE task
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-38450 : error computing a stored attribute for the expression set.
  • ora-04078 : OLD and NEW values cannot be identical
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • 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.