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-25957: join index where clause cannot contain cycles

1 Answers  


ORA-31055: A null XMLType element cannot be inserted into RESOURCE_VIEW

1 Answers  


TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


ORA-06574: Function string references package state, cannot execute remotely

1 Answers  


NID-00500: Keyword Description (Default)

1 Answers  


ORA-25019: too much concurreny

1 Answers  


NNL-00294: No entries found

1 Answers  


PLS-00235: the external type is not appropriate for the parameter

1 Answers  


NNL-00274: server not started, errors follow

1 Answers  


ORA-32407: cannot exclude new values when materialized view log includes new values

1 Answers  


ORA-27199: skgfpst: sbtpcstatus returned error

1 Answers  


ORA-16150: FINISH recovery performed on another, older standby database

1 Answers  


Categories