ORA-02242: no options specified for ALTER INDEX

Question Posted / guest

ORA-02242: no options specified for ALTER INDEX..

Answer / guest

Cause: No options specified.

Action: Specify at least one of REBUILD, INITRANS, MAXTRANS,
or STORAGE.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

1 No

More Oracle Errors Interview Questions

TNS-01057: Program name: string

LFI-00141: Unable to abort file in operation string.

ORA-01779: cannot modify a column which maps to a non key-preserved table

TNS-01036: %s established:string refused:string

LSX-00156: type is final and no derivations are allowed

ORA-30508: client logon triggers cannot have BEFORE type

ORA-08001: maximum number of sequences per session exceeded

DGM-16905: Failed.

ORA-02439: Unique index on a deferrable constraint is not allowed

TNS-12223: TNS:internal limit restriction exceeded

ORA-07534: scginq: $getlki unexpected return on lockid string

ORA-09913: Malloc of dummy name failed.

For more Oracle Errors Interview Questions Click Here