ORA-14157: invalid subpartition name

Cause : a usbpratiitonn am eoft hef or mr i sexepctde btu nto persetn.

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

enetr na approrpiaet sbupatritoin anme.

update : 23-08-2017
ORA-14157

ORA-14157 - invalid subpartition name
ORA-14157 - invalid subpartition name

  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • ora-31675 : worker process interrupt for unexpected death of master process
  • ora-28152 : proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
  • ora-19202 : Error occurred in XML processingstring
  • ora-02427 : create view failed
  • ora-28053 : the account is inactive
  • ora-00354 : corrupt redo log block header
  • ora-08193 : Flashback Table operation is not allowed on temporary tables
  • ora-22612 : TDS does not describe a collection TDS
  • ora-10570 : Test recovery complete
  • ora-31491 : could not add logfile to LogMiner session
  • ora-14085 : partitioned table cannot have column with LONG datatype
  • ora-12223 : TNS:internal limit restriction exceeded
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-09282 : sllfrb: error reading records
  • ora-21501 : program could not allocate memory
  • ora-02206 : duplicate INITRANS option specification
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-27467 : invalid datatype for string value
  • ora-24359 : OCIDefineObject not invoked for a Object type or Reference
  • ora-24383 : Overflow segment of an IOT cannot be described
  • ora-06771 : TLI Driver: error reading version
  • ora-15072 : command requires at least string failure groups, discovered only string
  • ora-12526 : TNS:listener: all appropriate instances are in restricted mode
  • ora-39765 : stream must be reset before used in a column array conversion
  • ora-29828 : invalid name for implementation type
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-26683 : invalid value for value_type
  • ora-14095 : ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
  • ora-32580 : both SYS and SYSTEM passwords must be provided
  • 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.