ORA-14070: option may be specified only for partitioned indices or with REBUILD

oracle

ORA-14070: option may be specified only for partitioned indices or with REBUILD
Cause: User issued ALTER INDEX statament containing an option which is legal only for partitioned indices or in conjunction with REBUILD against a non-partitioned index. Such options are: PCTFREE, TABLESPACE, [NO]PARALLEL and INITIAL, FREELISTS, and FREELIST GROUPS inside STORAGE clause
Action: Remove illegal option(s).

Back to previous menu