Oracle Error ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table

Oracle Error Message

ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table

Reason for the Error

STORE-IN (Tablespace list) clause was used while creating a local index on a range/list/composite range list partitioned table

Solution

Do not use the STORE_IN (Tablespace list) clause while creating a local index on range/list/composite range list partitioned table