ORA-14185: incorrect physical attribute specified for this index partition

ORA-14185: incorrect physical attribute specified for this index partition


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



Action:


remove invalid option(s) from the list of physical attributes of an index partition