ORA-14158: too many subpartition descriptions

Cause : CRAETET ABEL o rCRAETEI NDXE cnotaniedt oom an ysupbarittino dsecrpitinos;m axmiumn umebr fo sbupatritoinsi s 0148755.

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

Reudcen umebr fo sbupatritoinst o ont xecede 1204K1-.

update : 25-09-2017
ORA-14158

ORA-14158 - too many subpartition descriptions
ORA-14158 - too many subpartition descriptions

  • ora-12835 : No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
  • ora-16039 : RFS request version mismatch
  • ora-26063 : Can not flashback to specified SCN value - Wrap: string Base: string.
  • ora-10575 : Give up restoring recovered datafiles to consistent state: out of memory
  • ora-30040 : Undo tablespace is offline
  • ora-01956 : invalid command when OS_ROLES are being used
  • ora-09290 : sksaalo: error allocating memory for archival
  • ora-09714 : Two Task interface: cannot obtain puname
  • ora-31444 : parameter error while acquiring lock on string
  • ora-24098 : invalid value string for string
  • ora-08264 : ora_addr: cannot close nameserver
  • ora-13638 : The user interrupted the current operation.
  • ora-25441 : duplicate column value for table alias: string
  • ora-07220 : slspool: wait error.
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-31165 : cannot load object-relational XML attribute using direct path
  • ora-26088 : scalar column "string" must be specified prior to LOB columns
  • ora-07846 : sllfop: string byte record too big for string byte user buffer
  • ora-24314 : service handle not initialized
  • ora-24025 : invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-01493 : invalid SAMPLE size specified
  • ora-19034 : Type not supported during schema generation
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-25010 : Invalid nested table column name in nested table clause
  • ora-16052 : DB_UNIQUE_NAME attribute is required
  • ora-27472 : invalid metadata attribute string
  • ora-27374 : insufficient privileges on event source queue
  • ora-02438 : Column check constraint cannot reference other columns
  • ora-28504 : ROWID not found in ROWID cache for heterogeneous database link
  • 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.