ORA-14070: option may be specified only for partitioned indices or with REBUILD
What triggered the Error:
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 clauseWhat should we do to fix it:
Remove illegal option(s).