Oracle Error ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD

Oracle Error Message

ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD

Reason for the Error

The RECOVERABLE option to ALTER INDEX was used without the REBUILD option.

Solution

Use ALTER INDEX REBUILD.