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

You are here: Home // Oracle 11g // 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. See the solution below.

Error solution: Remove the option VISIBLE|INVISIBLE.

Database version: Oracle 11g Release 2 (11.2)