Oracle Solution for Error ora-14178

Solution for Oracle Error ORA-14178

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

What triggered the Error:

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

What should we do to fix it:

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