Oracle Solution for Error ora-14177

Solution for Oracle Error ORA-14177

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

What triggered the Error:

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

What should we do to fix it:

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