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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00325: archived log for thread string, wrong thread # string in header

1 Answers  


ORA-29665: Java thread deadlock detected

1 Answers  


ORA-37128: (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.

1 Answers  


PCC-02115: Unable to open output file for writing

1 Answers  


ORA-36776: (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

1 Answers  






ORA-13115: [string]_EDGE$ table does not exist

1 Answers  


PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

1 Answers  


KUP-04068: internal error fetching attribute string

1 Answers  


TNS-12585: TNS:data truncation

1 Answers  


ORA-23430: argument "string" cannot be NULL or empty string

2 Answers  


ORA-16036: invalid MANAGED recovery CANCEL option

1 Answers  


ORA-24162: name value pair list is full, cannot add another entry

1 Answers  


Categories