Oracle – Can’t Drop Index with Dot in Name

indexoracle

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

Best Answer

Use this one:

DROP INDEX SYSTEM."IX_isbn_send_h.D_STAT";

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