Home » SQL & PL/SQL » SQL & PL/SQL » Duplicated object
Duplicated object [message #37347] Fri, 01 February 2002 07:24 Go to next message
Luca
Messages: 5
Registered: November 2001
Junior Member
Hi All,

a simple (I hope) question from an Oracle beginners. 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 (8.0.5 on Unixware) 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
Re: Duplicated object [message #37351 is a reply to message #37347] Fri, 01 February 2002 10:49 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
it's not Unixware, it's your DDL syntax.

create table "PippO" (...); is different to:
create table pippo (...); OR
create table PIPPO (...);
Without quotes (much preferred) you get an upper case tablename.
Many tools use quotes to preserve the case, but you shouldn't be using them.
Previous Topic: Report error from an insert and rollback
Next Topic: Restricting to update some rows in table
Goto Forum:
  


Current Time: Sat Apr 04 23:19:35 CDT 2020