ORA-37185: length of string (string) exceeds maximum (string)

Cause : The user passed an excessively long value

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

Specify a legal value

update : 26-09-2017

ORA-37185 - length of string (string) exceeds maximum (string)
ORA-37185 - length of string (string) exceeds maximum (string)

  • ora-00109 : invalid value for attribute string: string
  • ora-16519 : the resource handle is invalid
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-27415 : repeat interval or calendar must start with the FREQ= clause
  • ora-28537 : no more result sets
  • ora-26049 : Unscoped REF column has non-existent table name.
  • ora-28176 : incorrect certificate version
  • ora-22295 : cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
  • ora-02327 : cannot create index on expression with datatype string
  • ora-19245 : XQ0025 - duplicate attribute name string
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-12013 : updatable materialized views must be simple enough to do fast refresh
  • ora-39700 : database must be opened with UPGRADE option
  • ora-29262 : bad URL
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-22057 : bad integer length [string]
  • ora-37156 : (string)
  • ora-36204 : (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.
  • ora-25278 : grantee name cannot be NULL
  • ora-38723 : Invalid SCN expression.
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-17504 : ksfddel:Failed to delete file string
  • ora-25258 : cannot register for notifications on an 8.0 style exception queue
  • ora-38465 : failed to create the privilege checking trigger due to: string
  • ora-06041 : NETDNT: disconnect failed
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-10946 : trace name context forever
  • ora-30752 : column or table string is not substitutable
  • ora-31604 : invalid string parameter "string" for object type string in function string
  • ora-16567 : Data Guard broker internal parser error at "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.