Oracle Error ORA-12999: cannot DROP or SET UNUSED a column that has been set unused

Oracle Error Message

ORA-12999: cannot DROP or SET UNUSED a column that has been set unused

Reason for the Error

An attempt was made to DROP or SET UNUSED a column that has already been ‘set unused’.

Solution

Use the DROP UNUSED COLUMNS option to remove the column.