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

RMAN-06434: some errors occurred while removing recovery catalog

ORA-06123: NETTCP: cannot set KEEPALIVE

TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX

NNO-00302: server stopped

DRG-13309: operation not supported by USER_LEXER

ORA-31089: schema "string" does not target namespace "string"

NNO-00330: server saved the config file "string".

PLS-00630: pipelined functions must have a supported collection return type

ORA-19900: RESETLOGS must be specified after recovery to new incarnation

ORA-29285: file write error

ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

ORA-19678: RMAN configuration value exceeds maximum length of string

For more Oracle Errors Interview Questions Click Here