ORA-14294: Number of partitions does not match number of subpartitions

Cause : When xechangnig a pratitioend tabel witha compsoite pratitio nthe nmuber o fpartiitons o fthe tbale muts matc hthe nmuber o fsubpatrition sof th ecompoiste patrition.

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

Ensur ethat hte numebr of aprtitinos in hte parittione dtablei s thes ame a sthe nmuber o fsubpatrition sin th ethe cmoposit epartiiton.

update : 25-09-2017
ORA-14294

ORA-14294 - Number of partitions does not match number of subpartitions
ORA-14294 - Number of partitions does not match number of subpartitions

  • ora-28346 : an encrypted column cannot serve as a partitioning column
  • ora-22806 : not an object or REF
  • ora-30765 : cannot modify scope for an unscoped REF column
  • ora-30076 : invalid extract field for extract source
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-31110 : Action failed as resource string is locked by name
  • ora-19718 : length for command id longer than string
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-35023 : (QFCHECK09) The analytic workspace and EIF file definitions of workspace object have incompatible partition definitions.
  • ora-12096 : error in materialized view log on "string"."string"
  • ora-19675 : file string was modified during proxy copy
  • ora-01222 : MAXINSTANCES of string requires MAXLOGFILES be at least string, not string
  • ora-36179 : (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
  • ora-22612 : TDS does not describe a collection TDS
  • ora-12557 : TNS:protocol adapter not loadable
  • ora-28515 : cannot get external object definitions from string
  • ora-31018 : Error deleting XML document
  • ora-32802 : value for string must be string
  • ora-29264 : unknown or unsupported URL scheme
  • ora-07706 : error in archive text: need disk file name
  • ora-29279 : SMTP permanent error: string
  • ora-12484 : invalid OS label
  • ora-12523 : TNS:listener could not find instance appropriate for the client connection
  • ora-27433 : cannot alter state of step string for job string.string to string
  • ora-12659 : Error received from other process
  • ora-13375 : the layer is of type [string] while geometry inserted has type [string]
  • ora-03200 : the segment type specification is invalid
  • ora-06805 : TLI Driver: could not send datagram SAP packet for SPX
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-31467 : no column found in the source table
  • 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.