Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.