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 : 29-06-2017

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

  • ora-35095 : (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
  • ora-14295 : column type or size mismatch between partitioning columns and subpartitioning columns
  • ora-16566 : unsupported document type
  • ora-19802 : cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
  • ora-19589 : %s is not a snapshot or backup control file
  • ora-27077 : too many files open
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-36863 : (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.
  • ora-19601 : output file is string string (string)
  • ora-31037 : Invalid XML attribute name string
  • ora-19602 : cannot backup or copy active file in NOARCHIVELOG mode
  • ora-24385 : Application context size or index is not valid
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-28170 : unsupported certificate version
  • ora-39162 : Transportable tablespace job require privileges
  • ora-06314 : IPA: Event set up failure
  • ora-19264 : XQ0044 - invalid namespace in attribute constructors
  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-10582 : The control file is not a backup control file
  • ora-24786 : separated transaction has been completed
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-16165 : LGWR failed to hear from network server
  • ora-29926 : association already defined for the object
  • ora-01352 : tablespace given for Logminer spill does not exist
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-12074 : invalid memory address
  • ora-28536 : error in processing Heterogeneous Services initialization parameters
  • ora-24338 : statement handle not executed
  • 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.