Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00955: name is already used by an existing object

RE: ORA-00955: name is already used by an existing object

From: Ian Cary (C) <Ian.Cary_at_ordnancesurvey.co.uk>
Date: Fri, 2 Dec 2005 14:00:14 -0000
Message-ID: <4AA808D68343824E8891632BD448AE6B1BEC40@OSMAIL.ordsvy.gov.uk>


"Surely if using CREATE OR REPLACE
it should not matter if the object already exists?"

Only if a package of that name exists. Your error indicates that you have another object with that name e.g.

TRYSTAG> create or replace procedure test as   2 begin
  3 null;
  4 end;
  5 /

Procedure created.

Elapsed: 00:00:00.05
TRYSTAG> create or replace package test as   2 begin
  3 null;
  4 end;
  5 /
create or replace package test as
*

ERROR at line 1:
ORA-00955: name is already used by an existing object

take a look in USER_OBJECTS and USER_SYNONYMS to see if anything called PACKAGE_PRINTERTYPE_SCITEX exists.

Cheers,

Ian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John Dunn Sent: 02 December 2005 13:55
To: oracle-l_at_freelists.org
Subject: ORA-00955: name is already used by an existing object

Can any one tell me why I get this error? Surely if using CREATE OR REPLACE it should not matter if the object already exists?

CREATE OR REPLACE PACKAGE package_printertype_scitex AS
*

ERROR at line 1:
ORA-00955: name is already used by an existing object

Package body created.

John Dunn
Product Consultant
Direct Dial +44 (0) 117 373 6122
Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0) 117 373 6114
Fax: +44 (0) 117 373 6115

www.sefas.com

--
http://www.freelists.org/webpage/oracle-l




This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 02 2005 - 08:02:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US