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..

Answer / guest

Cause: User attempted to add or coalesce an index partition
of a global index not partitioned by hash method.

Action: Issue the statement on a global index partitioned by
hash method. or if the index is partitioned by range method
consider using split/drop instead of add/coalesce.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27471: window "string.string" is already closed

1 Answers  


ORA-07415: slpath: allocation of memory buffer failed.

1 Answers  


PCC-02351: illegal datatype equivalencing operation

1 Answers  


ORA-32158: Invalid type passed

1 Answers  


TNS-12561: TNS:unknown error

1 Answers  






NNL-01006: META VIOLATION responses received: number

1 Answers  


ORA-25138: %s initialization parameter has been made obsolete

1 Answers  


ORA-36639: (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.

1 Answers  


ORA-06421: NETCMN: Error detected in the read-in data

1 Answers  


ORA-07591: spdde: $GETJPIW failure

1 Answers  


ORA-07484: snlkput: cannot convert(put) lock.

1 Answers  


RMAN-06041: cannot switch file number to copy of file number

1 Answers  


Categories