ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS

Cause : ALTER TABLE MERGE SUBPARTITIONS contained more than one resulting subpartition for the MERGE

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

Ensure that the statement describes exactly one subpartition as the target that need to be MERGEd

update : 25-04-2017
ORA-14635

ORA-14635 - only one resulting subpartition can be specified for MERGE SUBPARTITIONS
ORA-14635 - only one resulting subpartition can be specified for MERGE SUBPARTITIONS

  • ora-14094 : invalid ALTER TABLE EXCHANGE PARTITION option
  • ora-16011 : Archivelog Remote File Server process in Error state
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-25281 : complete reciever information not provided to non-repudiate reciever
  • ora-17618 : Unable to update block 0 to version 10 format
  • ora-24436 : Invalid statement Handle.
  • ora-36993 : (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-38724 : Invalid option to the FLASHBACK DATABASE command.
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-10665 : Inject Evil Literals
  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-12417 : database object "string" not found
  • ora-07715 : sksadtd: could not dismount archival device (SYS$DISMNT failure)
  • ora-31168 : Node localname and namespace values should be less than 64K
  • ora-22339 : cannot alter to not final since its attribute column is substitutable
  • ora-01500 : failure in getting date/time
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-12851 : PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-15051 : file 'string' contains string error(s)
  • ora-32132 : maximum iterations cannot be changed
  • ora-16800 : redo transport service for a standby database incorrectly set to ALTERNATE
  • ora-37139 : (XSCCOMP14) Cannot AGGREGATE workspace object using AGGMAP workspace object because you can not AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE using an AGGMAP with a PROTECT clause.
  • ora-01494 : invalid SIZE specified
  • ora-27126 : unable to lock shared memory segment in core
  • ora-19110 : unsupported XQuery expression
  • ora-22901 : cannot compare nested table or VARRAY or LOB attributes of an object type
  • ora-27064 : cannot perform async I/O to file
  • 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.