ORA-14141: ALTER INDEX VISIBLE|INVISIBLE may not be combined with other operations From Toad

alter index pk_test invisible;
 ORA-14141: ALTER INDEX VISIBLE|INVISIBLE may not be combined with other operations
 
Solution:
Here is the work around.
Option 1:
Just remove the semicolon from the end of the command
alter index pk_test invisible;

 

Option 2:

begin
execute immediate alter index pk_test invisible;

end;

Comments