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 : 26-04-2017

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

  • ora-02366 : The following index(es) on table string were processed:
  • ora-25965 : fact table must be included in the from clause
  • ora-26079 : file "string" is not part of table string.string
  • ora-30944 : Error during rollback for XML schema 'string' table string column 'string'
  • ora-19233 : XQ0013 - invalid pragma
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • ora-15020 : discovered duplicate ASM disk "string"
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-27039 : create file failed, file size limit reached
  • ora-00310 : archived log contains sequence string; sequence string required
  • ora-25442 : too many column values for table alias: string
  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-02725 : osnpbr: cannot send break signal
  • ora-38951 : Target platform string not cross platform compliant
  • ora-13835 : invalid attribute name specified
  • ora-15115 : missing or invalid ASM disk size specifier
  • ora-34177 : (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.
  • ora-24503 : codepoint length overflows for piecewise operation
  • ora-27044 : unable to write the header block of file
  • ora-02375 : conversion error loading table string.string partition string
  • ora-25957 : join index where clause cannot contain cycles
  • ora-33263 : Could not create analytic workspace string
  • ora-09708 : soacon: failed to bind socket to port.
  • ora-02722 : osnpui: cannot send break message to orapop
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-14616 : table is not subpartitioned by List method
  • ora-24368 : OCI mutex counter non-zero when freeing a handle
  • ora-06901 : CMX: no local name assigned to local application
  • ora-16806 : supplemental logging is not turned on
  • ora-25952 : join index must only contain inner equi-joins
  • 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.