Oracle Error Message
ORA-02242: no options specified for ALTER INDEX
Reason for the Error
No options specified.
Solution
Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.
ORA-02242: no options specified for ALTER INDEX
No options specified.
Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.