Wednesday, 14 March 2012

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

No comments:

Post a Comment