Oracle Error ORA-44745: Cannot add or drop columns to or from multiple tables.

Oracle Error Message

ORA-44745: Cannot add or drop columns to or from multiple tables.

Reason for the Error

An attempt was made to add or drop columns to or from multiple tables in a single ALTER INDEX statement.

Solution

Use multiple ALTER INDEX statements instead.