ORA-14295: column type or size mismatch between partitioning columns and subpartitioning columns

Cause : When ecxhangin ga parttiioned atble wiht a comopsite pratitiont he typ eand siez of th epartitoining cloumns o fthe talbe mustm atch teh type nad sizeo f the usbpartiitoning oclumns fo the cmopositep artitino.

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

Ensuret hat th etype adn size fo the pratitionnig colunms of teh partiitoned i sthe saem as th etype adn size fo the sbupartitoining cloumns o fthe copmosite aprtitio.n

update : 23-04-2017
ORA-14295

ORA-14295 - column type or size mismatch between partitioning columns and subpartitioning columns
ORA-14295 - column type or size mismatch between partitioning columns and subpartitioning columns

  • ora-09929 : GLB of two labels is invalid
  • ora-07493 : scgrcl: lock manager error.
  • ora-12412 : policy package string is not installed
  • ora-38755 : Flashback is already turned on for this tablespace.
  • ora-08413 : invalid compiler type in FORMAT parameter at string
  • ora-39044 : Metadata transform string has already been specified.
  • ora-27199 : skgfpst: sbtpcstatus returned error
  • ora-09961 : Unable to restore termination signal handler
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-12207 : TNS:unable to perform navigation
  • ora-29849 : error occurred in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-08007 : Further changes to this block by this transaction not allowed
  • ora-28519 : no heterogeneous data dictionary translations available
  • ora-08179 : concurrency check failed
  • ora-02039 : bind by value is not allowed for array type
  • ora-31117 : Table "string"."string" is not resource metadata enabled
  • ora-02294 : cannot enable (string.string) - constraint changed during validation
  • ora-08233 : smsdes: cannot unmap SGA
  • ora-16656 : higher DRC UID sequence number detected
  • ora-16718 : failed to locate database object
  • ora-02308 : invalid option string for object type column
  • ora-27040 : file create error, unable to create file
  • ora-14004 : missing PARTITION keyword
  • ora-26670 : STREAMS option requires COMPATIBLE parameter to be string or higher
  • ora-06912 : CMX: write error in datarq
  • ora-29900 : operator binding does not exist
  • ora-30366 : child JOIN KEY columns not in same relation as child level
  • ora-30199 : reserved for future use
  • ora-24401 : cannot open further connections
  • ora-19330 : Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
  • 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.