incorrect physical attribute specified for this index partition

Solution ID:ORA-14185

Type: Oracle

Cause

unexpected option was encountered while parsing physical attributes of a local index partition; valid options for Range or Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE, PCTUSED, LOGGING and TABLESPACE; but only TABLESPACE may be specified for Hash partitions STORE IN () is also disallowed for all but Composite Range partitions

Actions

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

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/9913262


Browse all solutions to database errors from Oracle, MS SQL, or MySQL