Oracle DBA, How To, Error, Cause and Action

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.

No comments:

Post a Comment

Thanks for your comment.