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 : 27-04-2017

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

  • ora-31030 : Unable to retrieve XML document
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-13265 : geometry identifier column string in table string is not of type NUMBER
  • ora-32002 : cannot create SPFILE already being used by the instance
  • ora-01265 : Unable to delete string string
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-27087 : unable to get share lock - file not readable
  • ora-07202 : sltln: invalid parameter to sltln.
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-23337 : priority or value not in priority group string
  • ora-06801 : TLI Driver: listen for SPX server reconnect failed
  • ora-01170 : file not found 'string'
  • ora-16580 : bad Data Guard NetSlave network link
  • ora-02437 : cannot validate (string.string) - primary key violated
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-33922 : (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-00292 : parallel recovery feature not installed
  • ora-16808 : unable to resolve the full path name
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-27469 : %s is not a valid string attribute
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-28038 : disallow O2LOGON
  • ora-25307 : Enqueue rate too high, flow control enabled
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-02230 : invalid ALTER CLUSTER option
  • ora-26006 : Incorrect bind variable in column string's sql expression - string
  • ora-06540 : PL/SQL: compilation error
  • ora-09811 : Unable to initialize package.
  • 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.