Home
Trouble shooting
 

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:

  1. The index exists but is in a different schema from the current.

  • Resolve this by explicitly specifying the index schema.

  1. The index does not exist or is misspelt.

  • Check the name of the index.