Monday, 19 March 2012

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

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

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 or drop instead of add or coalesce.

No comments:

Post a Comment