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 : 17-08-2017

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

  • ora-26052 : Unsupported type number for SQL expression on column string.
  • ora-13703 : The snapshot pair [string, string] for database_id string and instance_id string are not found in the current repository.
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-10902 : disable seghdr conversion for ro operation
  • ora-00705 : inconsistent state during start up; shut down the instance, then restart it
  • ora-36740 : A CHILDLOCK was detected in your valueset
  • ora-29521 : referenced name string could not be found
  • ora-01104 : number of control files (string) does not equal string
  • ora-02493 : invalid file increment size in NEXT clause
  • ora-23308 : object string.string does not exist or is invalid
  • ora-32144 : Cannot perform operation on a null interval
  • ora-14194 : only one subpartition may be rebuilt
  • ora-30962 : inconsistent ODCI input arguments
  • ora-12663 : Services required by client not available on the server
  • ora-16401 : archivelog rejected by RFS
  • ora-24273 : translation text is required if translation type is T or S
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-28171 : unsupported Kerberos version
  • ora-00823 : Specified value of sga_target greater than sga_max_size
  • ora-16661 : the standby database needs to be reinstated
  • ora-06416 : NETCMN: error on test
  • ora-01041 : internal error. hostdef extension doesn't exist
  • ora-28365 : wallet is not open
  • ora-08103 : object no longer exists
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-31044 : Top-level prefix length string exceeds maximum string
  • ora-24129 : table name string does not start with string prefix
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-08102 : index key not found, obj# string, file string, block string (string)
  • ora-02344 : cannot revoke execute on a type with table dependents
  • 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.