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.