Oracle / PLSQL: ORA-01418 Error Message

Learn the cause and how to resolve the ORA-01418 error message in Oracle.

Description

When you encounter an ORA-01418 error, the following error message will appear:

• ORA-01418: specified index does not exist

Cause

You have referenced an index that does not exist in an ALTER INDEX, DROP INDEX, or VALIDATE INDEX command.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Make sure that your index exists before referencing it in an ALTER INDEX, DROP INDEX, or VALIDATE INDEX command.

You can list all of the indexes that exist by querying the ALL_INDEXES Oracle system table:

SELECT *
FROM ALL_INDEXES;