Oracle can't drop index with . in name? 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&lt;&gttable_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 this one:

DROP INDEX SYSTEM."IX_isbn_send_h.D_STAT";


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