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

From: Spencer <spencerp_at_swbell.net>
Date: Tue, 30 Jan 2001 23:32:08 -0600
Message-ID: <hrNd6.507$nD1.9523@nnrp1.sbc.net>

drop index "PrimaryKey" ;

object names in Oracle are case sensitive, and when a SQL statement is interpretted, all object names that are not enclosed in double quotes are translated to upper case.

the "MixedCaseObjectNamingStyle" appears often as the handiwork of developers familiar with "MicrosoftDataBaseProducts". If you are going to create objects with mixed case, you must enclose the object names in double quotes whenever they are referenced.

"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:jkbc7t8emupei2ludbmmmp097v5kov2v7j_at_4ax.com...
> 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
Received on Tue Jan 30 2001 - 23:32:08 CST