ORA-14638: cannot MERGE subpartitions in different Range Composite partitions

Cause : Attempted to MERGE subpartitions in different Range Composite partitions

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

Reissue the command after ensuring that the 2 subpartitions being merged lie in the same composite partition

update : 24-05-2017
ORA-14638

ORA-14638 - cannot MERGE subpartitions in different Range Composite partitions
ORA-14638 - cannot MERGE subpartitions in different Range Composite partitions

  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-01617 : cannot mount: string is not a valid thread number
  • ora-09291 : sksachk: invalid device specified for archive destination
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-01537 : cannot add file 'string' - file already part of database
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-02383 : illegal cost factor
  • ora-27192 : skgfcls: sbtclose2 returned error - failed to close file
  • ora-27073 : Trying to close a file which has async I/Os pending to be dequeued
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-22291 : Open LOBs exist at transaction commit time
  • ora-08447 : syntax error in USAGE clause in mask options
  • ora-03264 : cannot drop offline datafile of locally managed tablespace
  • ora-09981 : skxfqdreg: Error Adding a page to the SDI buffer pool
  • ora-16228 : Insufficient recovery for logical standby
  • ora-39062 : error creating master process string
  • ora-30066 : test support - drop rollback segment wait
  • ora-13436 : GeoRaster metadata dimensionSize error
  • ora-07431 : fork failed
  • ora-30962 : inconsistent ODCI input arguments
  • ora-30020 : UNDO_MANAGEMENT=AUTO needs Compatibility string or greater
  • ora-29556 : object type has changed
  • ora-06754 : TLI Driver: unable to get local host address
  • ora-31512 : name cannot contain double quotation marks
  • ora-25244 : dequeue index key not found, QUEUE string, rowid string
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-01891 : Datetime/Interval internal error
  • ora-10706 : Print out information about global enqueue manipulation
  • ora-39091 : unable to determine logical standby and streams status
  • ora-29261 : bad argument
  • 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.