Oracle database error code ORA-14070 – option may be specified only for partitioned indices or with REBUILD

Oracle Database Error Code ORA-14070 Description :
option may be specified only for partitioned indices or with REBUILD
Error 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

How to Solve :
Remove illegal option(s).


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»