Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00955: when I try to create table. But no objects with the name found.

OlgaTogiOct 11 2016 — edited Oct 13 2016

Hi all.

There are 2 users:

MY_USER1 and MY_USER2.

There is a table:

MY_USER1.TABLE1

and synonym MY_USER2.TABLE1 for MY_USER1.TABLE1.

I drop the synonym in MY_USER2:

drop synonym TABLE1 force;

and try to create the clon of the table in MY_USER2:

  create table TABLE1(

   new_field VARCHAR2(100)

)

and get the next error:

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

select * from user_objects where object_name like 'TABLE1';

no rows

What could be the problem???

Thanks.

This post has been answered by Sven W. on Oct 11 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2016
Added on Oct 11 2016
19 comments
4,112 views