Re: Problem with use of synonym command

From: Marc Parkinson <marcpark_at_starband.net>
Date: Thu, 31 Oct 2002 04:04:16 GMT
Message-ID: <qZ1w9.3707$Bj6.1485157536@twister2.starband.net>

Try the following
drop synonym test;
create PUBLIC synonym test
for test.

Do this under your account.

Marc Parkinson
Senior Oracle Engineer

"gamaz" <gamaz_at_earthlink.net> wrote in message news:tDKu9.7747$6F4.689187_at_newsread2.prod.itd.earthlink.net...
> Hi, I created a table called test under my userid (jdoe). I would now like
> to create a synonym to this table so that users who have access to this
> table does not have to type jdoe.test all the time in order to refer to
the
> table test.
>
> I am issuing the following command in order to create a synonym test but
an
> error
> message keeps coming.
>
> COMMAND:
>
> create synonym test
> for jdoe.test;
>
> ERROR:
>
> ERROR at line 1:
> ORA-01471: cannot create a synonym with same name as object.
>
> My question is: How to implement synonym so that user do not have to type
> prefix jdoe and can still refer to the table as test?
>
> Thanks.
>
>
Received on Wed Oct 30 2002 - 22:04:16 CST