Oracle Error ORA-14193: invalid ALTER INDEX MODIFY SUBPARTITION option

Oracle Error Message

ORA-14193: invalid ALTER INDEX MODIFY SUBPARTITION option

Reason for the Error

An option other than UNUSABLE, ALLOCATE EXTENT, DEALLOCATE UNUSED was specified in an ALTER INDEX MODIFY SUBPARTITION statement.

Solution

Specify only legal options.