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 : 26-04-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-12039 : unable to use local rollback segment "string"
  • ora-36312 : (PHYS00) workspace object must be a dimension or dimensioned variable.
  • ora-13607 : The specified task or object string already exists
  • ora-07742 : slemop: $CONNECT failure
  • ora-12206 : TNS:received a TNS error during navigation
  • ora-23489 : duplicate entry "string"
  • ora-13779 : invalid load option
  • ora-02266 : unique/primary keys in table referenced by enabled foreign keys
  • ora-13374 : SDO_MBR not supported for geodetic data
  • ora-13142 : invalid PROXIMITY window definition
  • ora-01526 : error in opening file 'string'
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-01907 : TABLESPACE keyword expected
  • ora-13110 : cannot drop topology with associated topo_geometry tables
  • ora-25501 : ALTER SYSTEM QUIESCE RESTRICTED command failed
  • ora-00318 : log string of thread string, expected file size string doesn't match string
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-31628 : error getting worker process exception
  • ora-25409 : failover happened during the network operation,cannot continue
  • ora-28513 : internal error in heterogeneous remote agent
  • ora-07236 : slemop: open error.
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-12724 : regular expression corrupt
  • ora-36761 : (XSLANGDM01) Analytic workspace string already contains a dimension (%J) with the string property.
  • ora-28177 : incorrect Kerberos ticket version
  • ora-16618 : response document of size "string" bytes is too large
  • ora-07257 : spdcr: translation error expanding program name.
  • ora-02784 : Invalid shared memory ID specified
  • ora-15039 : diskgroup not dropped
  • ora-01627 : rollback segment number 'string' is not online
  • 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.