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

NZE-29102: Cannot add certificate bag.

1 Answers  


ORA-07274: spdcr: access error, access to oracle denied.

2 Answers  


ORA-27467: invalid datatype for string value

1 Answers  


ORA-13019: coordinates out of bounds

1 Answers  


ORA-13429: invalid xCoefficients or yCoefficients parameter(s)

1 Answers  






PCB-00322: EXEC SQL LOB statements an Oracle extension

1 Answers  


TNS-04010: Command cannot be issued before the ADMINISTER command.

1 Answers  


ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.

1 Answers  


DRG-10513: index string metadata is corrupt

1 Answers  


ORA-32150: Cannot perform operation on a null timestamp

1 Answers  


ORA-38444: statistics do not exist for the expression set

1 Answers  


ORA-13332: invalid LRS point

1 Answers  


Categories