ORA-14164: subpartition "string": INITRANS value must be less than MAXTRANS value

Cause : aVul efoI INRTNA Saw sofnu dotb ergaeet rhtnat ah tfoM XARTNA Sof r auspbraititnow ohesn ma ee(pxiliclt ypscefiei dybt ehu es)ri sidpsaley dnit ih semssga.eN to ehttai fNITIARSNa dno/ rAMTXARSNv laeu sof rhtsis buaptrtioi newern tos epicifdee pxiliclt,yd feuatlv laeu stap raititnol-velew uodlb esude .fI ,nit ru,nd feuatlI INRTNA Sna/droM XARTNA Savulsea taptrtioi-nelev lewern tos epicifde ,edaflu tavulsef rot ehp raititnodet baelo rnied xowlu debu es.dI fhtso eavulsew re elaosn tos epicifdee pxiliclt,ys syet medaflustw uodlb esude.

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

neusert ah tavul efoI INRTNA Sw(ehhtres epicifdee pxiliclt yrod revidef or mht eedaflu tavul etap raititnol-vele ,atlb-eelev lroi dnxel-vele )sin orgaeet rhtnat ah tfoM XARTNAS

update : 30-04-2017
ORA-14164

ORA-14164 - subpartition "string": INITRANS value must be less than MAXTRANS value
ORA-14164 - subpartition "string": INITRANS value must be less than MAXTRANS value

  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-14456 : cannot rebuild index on a temporary table
  • ora-00706 : error changing format of file 'string'
  • ora-38781 : cannot disable media recovery - have guaranteed restore points
  • ora-07222 : slspool: line printer spooler command exited with an error.
  • ora-00368 : checksum error in redo log block
  • ora-01373 : insufficient memory for staging persistent LogMiner session
  • ora-13330 : invalid MASK
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-31407 : end_date must be greater than the begin_date
  • ora-28560 : error in configuration of agent process
  • ora-27451 : %s cannot be NULL
  • ora-12401 : invalid label string: string
  • ora-22309 : attribute with name "string" already exists
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-06914 : CMX: unexepected event during start of oracle
  • ora-38611 : FI input cursor's item type is not supported
  • ora-19101 : CONTENT keyword expected
  • ora-31632 : master table "string.string" not found, invalid, or inaccessible
  • ora-38790 : BEFORE must be specified with RESETLOGS
  • ora-12519 : TNS:no appropriate service handler found
  • ora-28117 : integrity constraint violated - parent record not found
  • ora-01751 : Invalid dump undo option
  • ora-01973 : Missing change number
  • ora-31519 : CDC subscription string already exists
  • ora-14633 : Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
  • ora-37083 : Invalid object string
  • ora-01260 : warning: END BACKUP succeeded but some files found not to be in backup mode
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-06608 : LU6.2 Driver: Reset occurred in receive state
  • 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.