OraFAQ Forum: SQL & PL/SQL » ORA-00955: name is already used by an existing object

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00955: name is already used by an existing object

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00955: name is already used by an existing object [message #169635]

Thu, 27 April 2006 18:23

Marc2000
Messages: 4
Registered: April 2006

Junior Member

Question: When I log in sqlplus as scott to oracle9i and tried to create a sequence using the following script:

CREATE SEQUENCE emp_empno_s
START WITH 8500
INCREMENT BY 10;

I always met error, ORA-00955: name is already used by an existing object. And whatever sequence name I used, the error is always there.

PS, in my oracle, there is no object using name emp_empno_s.

Report message to a moderator

Re: ORA-00955: name is already used by an existing object [message #169637 is a reply to message #169635]

Thu, 27 April 2006 18:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It works for me.

SQL> CREATE SEQUENCE emp_empno_s
2 START WITH 8500
3 INCREMENT BY 10;

Sequence created.

Report message to a moderator

Re: ORA-00955: name is already used by an existing object [message #169639 is a reply to message #169635]

Thu, 27 April 2006 19:42

andrew again
Messages: 2577
Registered: March 2000

Senior Member

select object_name, object_type from users_objects where object_name = 'EMP_EMPNO_S'

Report message to a moderator

Re: ORA-00955: name is already used by an existing object [message #169657 is a reply to message #169639]

Fri, 28 April 2006 00:24

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Just to avoid another ORA-00942 question:

... from user_objects ... (instead of "users_objects")

Report message to a moderator

Re: ORA-00955: name is already used by an existing object [message #169658 is a reply to message #169657]

Fri, 28 April 2006 00:37

Frank
Messages: 7901
Registered: March 2000

Senior Member

Check your script. Could it be you have an extra / at the end?

Report message to a moderator

Re: ORA-00955: name is already used by an existing object [message #169929 is a reply to message #169635]

Sun, 30 April 2006 17:30

Marc2000
Messages: 4
Registered: April 2006

Junior Member

Thanks buddies.

I wrote the scripts in a sql files as bellow,

CREATE SEQUENCE emp_empno_s
2 START WITH 8500
3 INCREMENT BY 10;
/

After remove / from the file, It executes successfully.

Report message to a moderator

Previous Topic:	Variable from another Package
Next Topic:	passing 20 variable with similar variable names to a procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 28 15:56:34 CDT 2025