Re: Cannot drop an index with a mixed-cased name

Dino Hsu wrote:

> Dear all,
>
> We have a table BTRX with a unique index PrimaryKey (its name
> is PrimaryKey, but it is not a primary key index, however). I
> can select it from USER_TABLES, ALL_TABLES, and DBA_TABLES,
> but I cannot drop it or rename it with the following SQL
> commends:
>
> drop index PrimaryKey;
> alter index PrimaryKey rename to PRIMARYKEY;
>
> Both return the message: ORA-01418: the index doesn't exist.
>
> The odd thing is all indexes come with all-upper-case names
> except for this one, and I cannot do anything to it without
> dropping the underlined table. Doesn't it look like a ghost
> haunting?
>
> Anyone has comments? Thanks in advance.
>
> Regards,
> Dino

Put the present name in quotes.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one