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 : 27-05-2017

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

  • ora-02359 : internal error setting attribute string
  • ora-19373 : invalid staging table or tablespace
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-12336 : cannot login to database (link name string)
  • ora-24331 : user buffer too small
  • ora-22929 : invalid or missing directory name
  • ora-30478 : Specified dimension does not exist
  • ora-19201 : Datatype not supported
  • ora-32009 : cannot reset the memory value for instance string from instance string
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-22336 : table contained 8.0 image format, must specify INCLUDING DATA
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-04090 : 'string' specifies same table, event and trigger time as 'string'
  • ora-37084 : Output valueset string must match string's dimensionality
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-31213 : DBMS_LDAP: PL/SQL - Invalid LDAP mod option.
  • ora-24042 : no propagation schedule exists for QUEUE string and DESTINATION string
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-06002 : NETASY: port read failure
  • ora-32052 : failed to start mapping service
  • ora-25109 : standby lock name space has illegal character 'string'
  • ora-13384 : error in network schema: string
  • ora-16004 : backup database requires recovery
  • ora-14278 : column type or size mismatch in EXCHANGE SUBPARTITION
  • ora-00209 : control file blocksize mismatch, check alert log for more info
  • ora-30556 : functional index is defined on the column to be modified
  • ora-30437 : all job queue processes have stopped running
  • ora-06005 : NETASY: dialogue file read failure
  • 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.