There is an existing VISIBLE index defined on the same set of columns.

Solution ID:ORA-14147

Type: Oracle

Cause

An attempt was made to define more than one VISIBLE index on the same set of columns. There can be only one VISIBLE index on the same set of columns. Hence ALTER INDEX VISIBLE was not supported on this index.

Actions

Remove the option INVISIBLE

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


Browse all solutions to database errors from Oracle, MS SQL, or MySQL