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-13852: Tracing for service(module/action) string is not enabled

1 Answers  


ORA-07259: spdcr: exec error, detached process failed in startup.

1 Answers  


ORA-30451: internal error

1 Answers  


ORA-26575: remote database does not support replication parallel propagation

1 Answers  


PLS-01902: : hex to raw conversion error

1 Answers  






CLSS-00099: logfile open failed for string, err string

1 Answers  


ORA-02420: missing schema authorization clause

1 Answers  


QSM-01056: no query rewrite for this DDL expression

1 Answers  


NZE-28758: memory release failure

1 Answers  


ORA-09340: Specified ORACLE_SID is either invalid or too long

1 Answers  


ORA-13624: The task string is executing and cannot be deleted or modified.

1 Answers  


ORA-26510: materialized view name: 'string' is greater than max. allowed length of string bytes

1 Answers  


Categories