Oracle Database 12c New Features

ORA-14147: There is an existing VISIBLE index defined on the same set of columns.

ORA-14147: There is an existing VISIBLE index defined on the same set of columns.


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.



Action:


Make all the indexes defined on the same set of columns as INVISIBLE and then reexecute this DDL.