I am trying to drop an index that has a dot(.) in its name and can't seem to do it (I'm logged in as the SYSTEM user, which owns the index). Any ideas?

SQL> select index_name,owner,status from all_indexes where owner<>table_owner;

INDEX_NAME                     OWNER                STATUS
------------------------------ -------------------- --------------------
IX_isbn_send_h.D_STAT          SYSTEM               VALID

SQL> drop index IX_isbn_send_h.D_STAT;
drop index IX_isbn_send_h.D_STAT
ERROR at line 1:
ORA-01418: specified index does not exist
  • Use quotation marks, @par!
    – elfcheg
    Commented Mar 22, 2015 at 23:58
  • I had tried single-quotes and that didn't work. For some reason putting it in double-quotes did. Make your comment an answer and I'll mark it correct.
    – par
    Commented Mar 23, 2015 at 1:13
  • 1
    – user1822
    Commented Mar 23, 2015 at 8:14
  • 1
    @par nevermind :) yep, you should use double quotes when refer to an object name and single quotes to indicate a character or string.
    – elfcheg
    Commented Mar 24, 2015 at 8:19

1 Answer 1


Use this one:


Note, when you use quotes, then names are case-sensitive in Oracle.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.