Oracle defaults to upper case. To use lower case letters in an object name
you need to enclose it in double quotes (i.e. "Pippo"). At some point,
someone must have created a table called "Pippo" using the double quotes.
You could create another table called "PippO" if you also used the
uotes. -jw
"Luca Saccarola" <lsaccarola_at_computercenter.it> wrote in message
news:Pine.WNT.4.33.0202011841061.1356-100000_at_w-saccarol...
> Hi All,
>
> a simple (I hope) question from an Oracle beginners. I'm using Oracle
> 8.0.5 on Unixware 7.0.1. The statement
>
> select table_name from user_tables where upper(table_name) = 'PIPPO'
>
> give me
>
> PIPPO
> Pippo
>
> So I've assumed that the db installation I'm playing with is case
> sensitive but when I've tried to create a new table named 'PippO' I've
> got:
>
> ORA-955: name is already used by an existing object
>
> Any tips ?
>
> Regards
>
>
Received on Wed Feb 06 2002 - 08:13:21 CST
