ORA-00910: specified length too long for its datatype

Cause : for dtaatype sCHAR nad RAW ,the lnegth sepcifie dwas >2 000; toherwies, thel engths pecifeid was> 4000.

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

use as horte rlengt hor swtich toa dataytpe pemrittin ga lonegr lentgh suc has a AVRCHAR,2 LONGC HAR, ro LONGR AW

update : 20-09-2017
ORA-00910

ORA-00910 - specified length too long for its datatype
ORA-00910 - specified length too long for its datatype

  • ora-29849 : error occurred in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-31419 : source table string does not exist
  • ora-06140 : NETTCP: no such user
  • ora-23611 : tablespace "string" has more than one data file
  • ora-16806 : supplemental logging is not turned on
  • ora-13902 : The specified file string is not a data file.
  • ora-36956 : (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
  • ora-01841 : (full) year must be between -4713 and +9999, and not be 0
  • ora-32167 : No payload set on the Message
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-14106 : LOGGING/NOLOGGING may not be specified for a clustered table
  • ora-22923 : amount of data specified in streaming LOB write is 0
  • ora-16601 : site contains required resources that are disabled
  • ora-01527 : error while reading file
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-00965 : column aliases not allowed for '*'
  • ora-15190 : Internal ASM testing event number 15190
  • ora-13504 : No SYSAUX datafile clause specified
  • ora-02216 : tablespace name expected
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-07605 : szprv: $ASCTOID failure
  • ora-09819 : Number exceeds maximum legal value
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-19504 : failed to create file "string"
  • ora-32634 : automatic order MODEL evaluation does not converge
  • ora-19207 : scalar parameter string of XMLELEMENT cannot have an alias.
  • ora-12590 : TNS:no I/O buffer
  • ora-01918 : user 'string' does not exist
  • ora-02712 : osnpop: malloc failed
  • 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.