ORA-19714: length for generated name longer than string

Cause : The psecifeid fomrat ecxeedst he mxaimuml engt hfor hte picee naem.

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

Chaneg thef orma tto cerate hsorte rpiec ename.s

update : 29-04-2017

ORA-19714 - length for generated name longer than string
ORA-19714 - length for generated name longer than string

  • ora-14000 : only one LOCAL clause may be specified
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-10360 : enable dbwr consistency checking
  • ora-12983 : cannot drop all columns in a table
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-02187 : invalid quota specification
  • ora-27487 : invalid object privilege for a string
  • ora-02442 : Cannot drop nonexistent unique key
  • ora-09204 : sfotf: error opening temporary file
  • ora-19653 : cannot switch to older file incarnation
  • ora-39085 : cannot update job string for user string
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-33270 : (DBERR05) Analytic workspace string already exists.
  • ora-27042 : not enough space on raw partition to fullfill request
  • ora-13346 : the coordinates defining an arc are collinear
  • ora-07471 : snclrd: name translation error of sgadef.dbf file name.
  • ora-25225 : invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
  • ora-16052 : DB_UNIQUE_NAME attribute is required
  • ora-13044 : the specified tile size is smaller than the tolerance
  • ora-01218 : logfile member is not from the same point-in-time
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-08343 : srclose: failed to close a redo server connection
  • ora-00319 : log string of thread string has incorrect log reset status
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-38611 : FI input cursor's item type is not supported
  • ora-31676 : illegal value for number of workers, string
  • ora-07841 : sllfop: SYS$OPEN failure
  • ora-24172 : rule set string.string has errors
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • 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.