Link to home
Start Free TrialLog in
Avatar of wasabi3689
wasabi3689Flag for United States of America

asked on

ORA-00955

I have the following error when I run the sql script

CREATE  SYNONYM abc FOR ABC
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object

In my .sql file
I have the following lines

CREATE  SYNONYM abc FOR ABC;
....
exit;


I think the error is because abc already existed

I want to know how I put a condition to say]

if object abc existed already, need to run

CREATE  SYNONYM abc FOR ABC;

the following statement is correct?

IF NOT EXISTS (abc)
CREATE  SYNONYM abc FOR ABC;
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
- duplicate answer from me. earlier expert have already covers it.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

No problem OP, it happens to ALL of us....