Oracle Database 12c New Features

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

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


Cause:


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



Action:


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