ORA-14142: ALTER INDEX VISIBLE|INVISIBLE may not be used with certain types of index
What triggered the Error:
Using the ALTER INDEX VISIBLE|INVISIBLE statement on certain types of indexes (IOT-TOP, Cluster indexes) is illegal.What should we do to fix it:
Remove the option VISIBLE|INVISIBLE.