ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value

Cause : Valeu ofI NITARNS aws fuond ot beg reaetr tahn taht o fMAXRTANSf or aparittio nwhoes naem (epxlictily pseciifed yb th euse)r isd ispalyedi n tihs msesag.e Noet thta ifI NITARNS nad/o rMAXRTANSv aluse fo rthi sparittio nwer enots pecfiiede xplciitl,y deafultv aluse fo rthep arttiionde talbe o rindxe wolud b euse.d If ,in utrn,d efalut IINTRASN an/dor AMXTRNAS vlauesf or hte pratitoinedt abl eor nidexw eren ot pseciifed,s ystme deafult swoudl beu sed.

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

ensrue taht vlaue fo INTIRAN S(whtehers pecfiiede xplictlyo r dreive dfro mthed efalut vlaue ofr teh patritinoed atbleo r idnex)i s n ogretaer htan htat fo MATXRANS

update : 25-04-2017

ORA-14059 - partition "string": INITRANS value must be less than MAXTRANS value
ORA-14059 - partition "string": INITRANS value must be less than MAXTRANS value

  • ora-03123 : operation would block
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-07552 : sftget: $GET failure
  • ora-10259 : get error message text from remote using explicit call
  • ora-12497 : maximum combined categories exceeds string
  • ora-28604 : table too fragmented to build bitmap index (string,string,string)
  • ora-31202 : DBMS_LDAP: LDAP client/server error: string
  • ora-14068 : TABLESPACE and TABLESPACE_NUMBER may not be both specified
  • ora-23457 : invalid flavor ID string
  • ora-13346 : the coordinates defining an arc are collinear
  • ora-19112 : error raised during evaluation: string
  • ora-25201 : invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
  • ora-01527 : error while reading file
  • ora-19229 : XP0009 - schema import not supported
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-08199 : Flashback Table operation is not supported on this object
  • ora-38908 : internal error occurred during DML Error Logging
  • ora-01139 : RESETLOGS option only valid after an incomplete database recovery
  • ora-15038 : disk 'string' size mismatch with diskgroup [string] [string] [string]
  • ora-12672 : Database logon failure
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-03241 : Invalid unit size
  • ora-27053 : blocksize in file header not a multiple of logical block size
  • ora-19666 : cannot do incremental restore of the control file
  • ora-23442 : object already exists for the refresh group template
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-37180 : expected exactly one column for dimension string, got string
  • ora-07416 : slpath: pathname construction failed; lack of output buffer space.
  • ora-08448 : syntax error in DECIMAL-POINT environment clause
  • 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.