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 : 24-07-2017
ORA-14158

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

  • ora-23355 : object string.string does not exist or is invalid at master site
  • ora-00201 : control file version string incompatible with ORACLE version string
  • ora-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-00322 : log string of thread string is not current copy
  • ora-38754 : FLASHBACK DATABASE not started; required redo log is not available
  • ora-12574 : TNS:redirection denied
  • ora-01666 : control file is for a standby database
  • ora-22808 : REF dereferencing not allowed
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-24376 : cannot register/get user callback for non-environment handle
  • ora-02366 : The following index(es) on table string were processed:
  • ora-12021 : materialized view "string"."string" is corrupt
  • ora-07449 : sc: usnewlock failed.
  • ora-06538 : statement violates string RESTRICT_REFERENCES pragma
  • ora-01180 : can not create datafile 1
  • ora-14109 : partition-extended object names may only be used with tables
  • ora-36764 : (XSAGGCNTMOVE02) AGGCOUNT variable workspace object must be of type INTEGER, not string.
  • ora-28022 : cannot grant external roles to global user or role
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-12323 : unable to open database (link name string)
  • ora-06432 : ssaio: Buffer Not Aligned
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-35024 : (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
  • ora-10920 : Cannot offline tablespace belonging to default temporary tablespace group
  • ora-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-01638 : parameter string does not allow ORACLE version string to mount cluster database
  • ora-16554 : translation not valid
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-13285 : Geometry coordinate transformation error
  • ora-08006 : specified row no longer exists
  • 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.