How to fix the Oracle error ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes?

In this post, you’ll learn more about the Oracle ErrorORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes

Reason for the Error ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes

STORE IN (DEFAULT) is valid only for local indexes.

How to fix the Error ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes ?

You can fix this error in Oracle by following the below steps

a) Specify a tablespace list in place of DEFAULT, or b) Remove STORE IN clause and specify tablespaces individually for each index partition.