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-02283: cannot alter starting sequence number

1 Answers  


ORA-04054: database link string does not exist

1 Answers  


ORA-25121: MINIMUM EXTENT value greater than maximum extent size

1 Answers  


ORA-25461: rule set not specified

1 Answers  


ORA-01581: attempt to use rollback segment (string) new extent (string) which is being allocated

1 Answers  






ORA-00439: feature not enabled: string

1 Answers  


ORA-30928: Connect by filtering phase runs out of temp tablespace

1 Answers  


ORA-39130: Object type string not imported. Base object name conflicts with the master table

1 Answers  


ORA-13633: The task string was interrupted and needs to be resumed.

1 Answers  


ORA-02163: invalid value for FREELIST GROUPS

1 Answers  


ORA-30444: rewrite terminated by the sql analyzer

1 Answers  


ORA-02146: SHARED specified multiple times

1 Answers  


Categories