Oracle Database 12c New Features

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

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).