All Oracle Error CodesOracle DBA Forum

ORA-02242:

no options specified for ALTER INDEX
Cause: No options specified.
Action: Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.