Oracle Database 12c New Features

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

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


Cause:


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



Action:


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