Oracle Error ORA-14142: ALTER INDEX VISIBLE|INVISIBLE may not be used with certain types of index

Oracle Error Message

ORA-14142: ALTER INDEX VISIBLE|INVISIBLE may not be used with certain types of index

Reason for the Error

Using the ALTER INDEX VISIBLE|INVISIBLE statement on certain types of indexes (IOT-TOP, Cluster indexes) is illegal.

Solution

Remove the option VISIBLE|INVISIBLE.