ORA-14616: table is not subpartitioned by List method

Cause : A subpartition maintenance operation such as ALTER TABLE MODIFY SUBPARTITION ADD|DROP VALUES or ALTER TABLE DROP|SPLIT|MERGE SUBPARTITION can only be performed on List subpartitioned objects

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

Re-issue the command against a List subpartitoned object.

update : 26-05-2017

ORA-14616 - table is not subpartitioned by List method
ORA-14616 - table is not subpartitioned by List method

  • ora-26512 : error pushing transaction to def$error
  • ora-01682 : read-only DB cannot allocate temporary space in tablespace string
  • ora-10707 : Simulate process death for instance registration
  • ora-03249 : Uniform size for auto segment space managed tablespace should have atleast string blocks
  • ora-13204 : failed to create spatial index table
  • ora-24008 : queue table string.string must be dropped first
  • ora-24191 : the property name string has existed
  • ora-14405 : partitioned index contains partitions in a different tablespace
  • ora-26666 : cannot alter STREAMS process string
  • ora-06709 : TLI Driver: message send failure
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-29279 : SMTP permanent error: string
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-06907 : CMX: error during connect confirmation
  • ora-12598 : TNS:banner registration failed
  • ora-07440 : WMON process terminated with error
  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-40104 : invalid training data for model build
  • ora-33002 : (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
  • ora-15183 : ASMLIB initialization error [string]
  • ora-02403 : plan table does not have correct format
  • ora-30032 : the suspended (resumable) statement has timed out
  • ora-31025 : Invalid document element
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-16555 : the Data Guard database is not active
  • ora-22335 : The client cannot work with an altered type
  • ora-16229 : PDML child string string string for parent string string string cannot be skipped.
  • ora-27056 : could not delete file
  • ora-25963 : join index must be created on tables
  • ora-01149 : cannot shutdown - file string has online backup set
  • 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.