Oracle Database 12c New Features

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

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


Cause:


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



Action:


Remove the option VISIBLE|INVISIBLE.