ORA-01418: specified index does not exist

ORA-01418: specified index does not exist

Oracle PL/SQL error message: ORA-01418: specified index does not exist.

Cause:

An ALTER INDEX, DROP INDEX, or VALIDATE INDEX statement specified the name of an index that does not exist. Only existing indexes can be altered, dropped, or validated. Existing indexes may be listed by querying the data dictionary.

Solution:

Check the name of an existing index in database and also in the ALTER INDEX, DROP INDEX, or VALIDATE INDEX statement.

Example:

ALTER INDEX first_name_idx23 RENAME TO first_name_idx659;

Output:

ORA-01418: specified index does not exist

Correct:

ALTER INDEX first_name_idx RENAME TO first_name_idx1;

Output:

index FIRST_NAME_IDX altered.