ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive

Cause : defniitino ofa talbe cnotaiend btoh PRATITOIN adn CLSUTERc lauess wihch si ilelgal

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

Remvoe oen oft he ocnflcitin gclasues

update : 21-08-2017

ORA-14026 - PARTITION and CLUSTER clauses are mutually exclusive
ORA-14026 - PARTITION and CLUSTER clauses are mutually exclusive

  • ora-32578 : password for SYS already specified
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-08106 : cannot create journal table string.string
  • ora-14286 : cannot COALESCE the only subpartition of this table partition
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-22370 : incorrect usage of method string
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-15003 : diskgroup "string" already mounted in another lock name space
  • ora-23338 : priority or value already in priority group string
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-38781 : cannot disable media recovery - have guaranteed restore points
  • ora-01125 : cannot disable media recovery - file string has online backup set
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-19102 : XQuery string literal expected
  • ora-26022 : index string.string was made unusable due to:
  • ora-13790 : invalid value for time limit
  • ora-00229 : operation disallowed: already hold snapshot control file enqueue
  • ora-29926 : association already defined for the object
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-24035 : AQ agent string is not a subscriber for queue string
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-07222 : slspool: line printer spooler command exited with an error.
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-25952 : join index must only contain inner equi-joins
  • ora-27456 : not all arguments of program "string.string" have been defined
  • ora-12663 : Services required by client not available on the server
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • 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.