wasabi3689
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;
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
- duplicate answer from me. earlier expert have already covers it.
No problem OP, it happens to ALL of us....