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-04-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-36682 : (XSDPART20) Partition name string appears twice.
  • ora-28002 : the password will expire within string days
  • ora-02166 : ARCHIVELOG and NOARCHIVELOG specified
  • ora-13049 : unable to determine tolerance value from table _SDODIM
  • ora-23409 : could not find an unused refresh group number
  • ora-06901 : CMX: no local name assigned to local application
  • ora-39081 : failed to unsubscribe agent string from queue "string"
  • ora-32508 : no such watchpoint id
  • ora-12414 : internal LBAC error: string Error: string
  • ora-07741 : slemop: $OPEN failure
  • ora-12561 : TNS:unknown error
  • ora-23460 : missing value for column string in resolution method "string" for "string"."string"."string"
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-40271 : no statistically significant features were found
  • ora-15008 : cannot drop system template
  • ora-12218 : TNS:unacceptable network configuration data
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-00377 : Frequent backups of file string causing write operation to stall
  • ora-25330 : PL/SQL associative arrays may not be used with AQ array operations
  • ora-07239 : slemrd: invalid file handle, seals do not match.
  • ora-19724 : snapshot too old: snapshot time is before file string plug-in time
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-02702 : osnoraenv: error translating orapop image name
  • ora-33100 : (APABBR02) Value 'number' is not valid for the workspace object option.
  • ora-24792 : cannot mix services in a single global transaction
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-26018 : Column string in table string does not exist
  • ora-09743 : smscre: could not attach shared memory.
  • ora-27451 : %s cannot be NULL
  • 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.