ORA-29372: identifier string is too long; it must be less than string characters

Cause : An atetmpt wsa madet o speicfy ani dentiifer thta is mroe tha n30 chraacter slong.

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

Use a nidentfiier taht is 03 charcaters ro lessi n lentgh.

update : 29-05-2017

ORA-29372 - identifier string is too long; it must be less than string characters
ORA-29372 - identifier string is too long; it must be less than string characters

  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-14159 : duplicate subpartition name
  • ora-36273 : (XSCGMDLAGG12) Dimension workspace object appears more than once in the QDR.
  • ora-36800 : (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
  • ora-07305 : ksmcsg: illegal database buffer size.
  • ora-17500 : ODM err:string
  • ora-09977 : skxfqhini: Error Connecting
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-02276 : default value type incompatible with column type
  • ora-25127 : RELY not allowed in NOT NULL constraint
  • ora-16185 : REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
  • ora-10372 : parallel query server kill event proc
  • ora-28504 : ROWID not found in ROWID cache for heterogeneous database link
  • ora-06003 : NETASY: port write failure
  • ora-23341 : user function required
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-10587 : Invalid count for ALLOW n CORRUPTION option
  • ora-22920 : row containing the LOB value is not locked
  • ora-01987 : client os username is too long
  • ora-13506 : operation failed due to invalid snapshot range (string, string)
  • ora-02804 : Allocation of memory failed for log file name
  • ora-32628 : invalid nesting of MODEL cell reference
  • ora-26053 : Row was not loaded due to conversion error.
  • ora-07598 : spwat: $SETIMR failure
  • ora-31158 : schema "string" currently being referenced
  • ora-29522 : authorization error for referenced name string.string
  • ora-08180 : no snapshot found based on specified time
  • 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.