Database Error Messages

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

ORA-29897

invalid domain index index_schema.index_name found on the same column
  • index_schema: The schema of the domain index.
  • index_name: The name of the domain index.

Cause

An attempt was made to create a domain index on the same column where an invalid domain index exists.


Action

Drop the invalid index and then reissue the CREATE INDEX statement.