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

ORA-00294: invalid archivelog format specifier 'string'

ORA-25468: column name not specified for alias: string

ORA-07704: error in archive text: need ':' after device name

ORA-30033: Undo tablespace cannot be specified as default user tablespace

ORA-24265: Insufficient privileges for SQL profile operation

ORA-14122: only one REVERSE or NOREVERSE clause may be specified

AMD-00113: PROCEDURE string, invalid operation

NNO-00270: ORACLE error string

ORA-12590: TNS:no I/O buffer

ORA-19616: output filename must be specified if database not mounted

QSM-02020: container column not in SELECT list with NOT NULL constraint

ORA-01164: MAXLOGFILES may not exceed string

For more Oracle Errors Interview Questions Click Here