Oracle Solution for Error ora-14142
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.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
