ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

Cause : User tatemptde to add or caolescea n indxe parttiion o fa gloabl indxe not aprtitinoed byh ash mtehod.

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

Issuet he sttaemento n a golbal idnex patritionde by hsah metohd. ori f thei ndex si parttiionedb y raneg methdo consdier usnig splti/dropi nstea dof ad/dcoalecse.

update : 27-06-2017
ORA-14640

ORA-14640 - add/coalesce index partition operation is valid only for hash partitioned global indexes
ORA-14640 - add/coalesce index partition operation is valid only for hash partitioned global indexes

  • ora-09956 : scgcm: unexpected lock status condition
  • ora-19116 : too many xmlspace declarations
  • ora-32504 : expecting one of string, string, string, or string but found string
  • ora-09802 : Conversion of binary label to string failed.
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-25115 : duplicate BLOCK option specification
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-24402 : error occured while creating connections in the pool
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-32810 : foreign queue string is not registered
  • ora-16176 : background dictionary build cannot be running
  • ora-02064 : distributed operation not supported
  • ora-01344 : LogMiner coordinator already attached
  • ora-01774 : Dump undo option specified more than once
  • ora-01137 : data file string is still in the middle of going offline
  • ora-36681 : (XSDPART19) Partitions string and string are out of order.
  • ora-01309 : invalid session
  • ora-06123 : NETTCP: cannot set KEEPALIVE
  • ora-36902 : (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.
  • ora-09951 : Unable to create file
  • ora-01619 : thread string is mounted by another instance
  • ora-32604 : invalid REBUILD option
  • ora-25132 : UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION
  • ora-37014 : (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.
  • ora-15093 : buffer only contains string bytes, I/O requested is string bytes
  • ora-13359 : extent does not have an area
  • ora-39154 : Objects from foreign schemas have been removed from import
  • ora-19121 : duplicate attribute definition - string
  • ora-38418 : ADT associated with the attribute set string does not exist
  • 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.