Share |

ORA-00955: Name is already used by an existing object

The object you are trying to create already exist.
eg:
SQL> desc t Name Null? Type ----------------------------------------- -------- ---------------------------- N NUMBER SQL> create table t(n number); create table t(n number) * ERROR at line 1: ORA-00955: name is already used by an existing object
Sometimes this error can occur when you do not expect it, for instance when you use create or replace .... When you get an error using the or replace clause, probably there's already an object with the same name, but a different type.
eg: SQL> create or replace procedure t as 2 begin 3 null; 4 end; 5 / create or replace procedure t as * ERROR at line 1: ORA-00955: name is already used by an existing object
Previous statement fails - although the or replace clause was given - because there's already a table with the same name.

You can use following select to check for those objects:
select object_name, object_type from user_objects where object_name='<object name>';

Welcome to our forum for Oracle error: ORA-00955 Add your own message

On 10-JUN-2009 15:22:58 Luis Saavedra asked: Drop synonym

Reply

How can I drop a public synonym on oracle???

On 10-JUN-2009 23:38:07 DbMotive replied

Reply

You can just issue following statement if you have the 'drop public synonym' privilege:

drop public synonym <synonym_name>;

On 21-SEP-2009 12:01:37 tinashe asked: how do i get rid of the message ORA-00955: name is already used by an existing object

Reply

Enter your message

On 21-SEP-2009 12:41:36 DbMotive replied

Reply

Either drop the object, or type to do create or replace ...

On 21-DEC-2009 19:51:02 sudipta asked: ORA-00955: name is already used by an existing object

Reply

this is my coding script.... dnt kno why the error is comming again and again... plz help me out..

create table student(
      stdId number check(stdId>=1 and stdId<=120),
      stdName varchar2(15) not null,
      stdAddress varchar2(25),
      stdPhNumber int,
      stdSex char(15),
      stdDept char (50),
      stdDegreeProg char (30),
      primary key (stdId)
      );

On 21-DEC-2009 21:30:10 DbMotive replied

Reply

You already have an object named test. If you want to recreate the table test, you will first need to drop it first:

drop table test;

On 10-MAR-2010 04:11:50 Rajesh Singh asked: Stored Procedure

Reply

Hi,

I have created few Sp's on two schema with same names. granted execute privilege to DB users for all the procs. when i am executing the proc it raised me the following error:

ORA-00955: Name is already used by an existing object

is it possible to create same sp in two different schema?

Please suggest me the appropriate solution.

its very urgent.

Thanks

On 10-MAR-2010 07:33:03 DbMotive replied

Reply

Yes, you can create 2 procedure with the same name in different schema's.

The error indicates that you are trying to create an object which already exists.

How do you execute this procedure?

On 25-JUN-2010 09:11:06 kavitha asked: Error

Reply

Hi,

I'm not able to create table,when ever i try i will get following error "-00955: Name is already used by an existing object " and i tried to resolve with the following

select object_name, object_type
from user_objects
where object_name='<object name>';

But it is giveing error .Please help.

Thanks & Regards,

Kavitha

On 28-JUN-2010 07:26:08 DbMotive.com replied

Reply

What error do you get when doing this select?

Can you post the steps performed using sqlplus?

Add your message

Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.

Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.

Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.