Don't panic!

Cry about...
Oracle Troubleshooting

ORA-01418: specified index does not exist

Symptom:

When performing some SQL on an index the following error is returned:

ORA-01418: specified index does not exist

Possible Causes and Remedies:

  • The index exists but is in a different schema from the current.
    • Resolve this by explicitly specifying the index schema.
  • The index does not exist or is misspelt.
    • Check the name of the index.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.