ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION

Cause : ALTER TABLE SPLIT SUBPARTITION contained more than 2 resulting subpartition for the SPLIT

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

Ensure that the statement describes exactly 2 subpartitions as the target of the SPLIT operation

update : 28-05-2017
ORA-14636

ORA-14636 - only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
ORA-14636 - only 2 resulting subpartition can be specified for SPLIT SUBPARTITION

  • ora-19953 : database should not be open
  • ora-06812 : TLI Driver: could not read the ethernet driver's node address
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-30972 : invalid ALTER INDEX option for XML Index
  • ora-31672 : Worker process string died unexpectedly.
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-02324 : more than one column in the SELECT list of THE subquery
  • ora-28535 : invalid Heterogeneous Services context
  • ora-02837 : Unable to unlink temporary file
  • ora-12234 : TNS:Redirect to destination
  • ora-39026 : master table is inconsistent on validation string
  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-31101 : Token "string" not given while locking resource "string"
  • ora-39094 : Parallel execution not supported in this database edition.
  • ora-30199 : reserved for future use
  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-22861 : invalid user-defined type
  • ora-16082 : logical standby is not initialized correctly
  • ora-13121 : layer type type mismatch with topo_geometry layer type
  • ora-02877 : smpini: Unable to initialize memory protection
  • ora-14274 : partitions being merged are not adjacent
  • ora-36832 : (XSLMGEN02) View token cannot be greater than 4000 bytes
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-30373 : object data types are not supported in this context
  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-13911 : Threshold not found
  • ora-38611 : FI input cursor's item type is not supported
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-29900 : operator binding does not exist
  • ora-36154 : (XSMXAGGR01) workspace object is not a data variable.
  • 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.