Database Error Messages

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

ORA-30554

Function-based index string.string is disabled.

Cause

Attempted to access a function-based index that was marked disabled because the function, on which the index depends, was changed.


Action

Perform one of the following actions:

  1. Drop the index using the DROP INDEX command.
  2. Rebuild the index using the ALTER INDEX REBUILD command.
  3. Enable the index using the ALTER INDEX ENABLE command.
  4. Make the index unusable using the ALTER INDEX UNUSABLE command.