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 : 17-08-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-12207 : TNS:unable to perform navigation
  • ora-37101 : (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-09710 : soarcv: buffer overflow.
  • ora-13853 : Tracing for service (module/action) string is already enabled
  • ora-24850 : failed to startup shared subsystem
  • ora-06778 : TLI Driver: error sending ccode
  • ora-13429 : invalid xCoefficients or yCoefficients parameter(s)
  • ora-22055 : unknown sign flag value [string]
  • ora-26005 : Invalid handle for direct path load
  • ora-19738 : cannot find language information for character set: 'string'
  • ora-12412 : policy package string is not installed
  • ora-01535 : rollback segment 'string' already exists
  • ora-06709 : TLI Driver: message send failure
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-32104 : cannot retrieve OCI error message
  • ora-27093 : could not delete directory
  • ora-13859 : Action cannot be specified without the module specification
  • ora-07578 : szprv: $FIND_HELD failure
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-28055 : the password will expire within string days
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-32629 : measure used for referencing cannot be updated
  • ora-27046 : file size is not a multiple of logical block size
  • ora-00226 : operation disallowed while alternate control file open
  • ora-19011 : Character string buffer too small
  • ora-12625 : TNS:missing argument
  • ora-28335 : referenced or referencing FK constraint column cannot be encrypted
  • ora-10646 : Too many recursive extensions during SYSTEM tablespace migration
  • ora-25240 : message ID and dequeue condition/correlation ID specified in dequeue options
  • 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.