Oracle Error ORA-44744: Cannot have more than one drop, add or modify operations in an ALTER INDEX statement.

Oracle Error Message

ORA-44744: Cannot have more than one drop, add or modify operations in an ALTER INDEX statement.

Reason for the Error

An attempt was made to have more than one add, modify, or drop column or group operations in the ALTER INDEX statement.

Solution

Use multiple ALTER INDEX statements instead.