ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value

Cause : Vaule fo IINTRNAS aws ofun dtob e rgeaetr htant ha tofM AXRTAN Sfo ra usbpratiitonw hoes nmube r(sbupatritoinsa ren umebre dstratign wtih )1 i sdipslaeyd ni tihs emssgae.N ot ethta i fINTIRASN adn/o rMATXRASN vlaue sfo rthsi sbupatritoin ewren ots peicfide epxliictl,y dfeautl vlaue satp arittino-lveelw oudl b eusde. fI, ni trun,d efualtI NIRTAN San/dorM AXRTAN Svaulesa t aprttiio-nleevl ewren ots peicfide, edfalut avluse fro teh pratiitonde tbaleo r nide xwolud eb uesd.I f htos evaulesw er ealos nto sepciifede xpilcilty,s ysetm edfalutsw oudl b eusde.

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

enusret ha tvaule fo IINTRNAS w(hehters peicfide epxliictl yord erviedf ro mth edeaful tvaule ta pratiitonl-evle, atbl-eleevl ro idnexl-evle) si n ograete rthna taht fo MXATRNAS

update : 29-06-2017
ORA-14163

ORA-14163 - subpartition number string: INITRANS value must be less than MAXTRANS value
ORA-14163 - subpartition number string: INITRANS value must be less than MAXTRANS value

  • ora-26091 : requested direct path operation not supported
  • ora-09313 : slsprom: error prompting user
  • ora-01967 : invalid option for CREATE CONTROLFILE
  • ora-02458 : HASHKEYS must be specified for a HASH CLUSTER
  • ora-09264 : sptpa: error flagging process
  • ora-15155 : version incompatible with the cluster
  • ora-01059 : parse expected before a bind or execute
  • ora-28232 : invalid input length for obfuscation toolkit
  • ora-12688 : Login failed: the SecurID server rejected the new pincode
  • ora-00341 : log string of thread string, wrong log # string in header
  • ora-07580 : spstp: $GETJPIW failure
  • ora-30365 : left relation in the JOIN KEY clause cannot be same as right
  • ora-14274 : partitions being merged are not adjacent
  • ora-39727 : COMPATIBLE must be set to 10.0.0.0.0 or higher
  • ora-12598 : TNS:banner registration failed
  • ora-19655 : cannot switch to incarnation with different resetlogs data
  • ora-23615 : Block number string does not exist for script string
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-24127 : TABLESPACE parameter specified with an ACTION other than CREATE_ACTION
  • ora-10662 : Segment has long columns
  • ora-28357 : password required to open the wallet
  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-07710 : sksaprs: file name buffer too small
  • ora-13435 : GeoRaster metadata dimension inconsistent
  • ora-36726 : (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-24352 : invalid COBOL display type passed into OCI call
  • ora-32639 : Aggregate functions on reference MODELs are not allowed
  • ora-00356 : inconsistent lengths in change description
  • ora-14008 : missing THAN keyword
  • 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.