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-01674: data file string is an old incarnation rather than current file

1 Answers  


LFI-01501: tmpnam() fails to generate temporary file name.

1 Answers  


PLS-00368: in RAISE statement, 'string' must be an exception name

1 Answers  


CLSR-01005: Error number encountered during altering database open mode

1 Answers  


ORA-23376: node string is not compatible with replication version "string"

1 Answers  


LFI-01002: Unable to read line from file.

1 Answers  


PCC-00025: Undeclared indicator variable "string" at line number in file string

1 Answers  


IMG-00925: unable to write to the ORDImageSignature object

1 Answers  


ORA-37041: (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.

1 Answers  


RMAN-06581: option string not supported

1 Answers  


ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file

1 Answers  


ORA-31158: schema "string" currently being referenced

1 Answers  


Categories