Re: Problem with use of synonym command

On Sun, 27 Oct 2002 05:15:05 GMT, gamaz wrote:

>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?

Under which user did you try to create the private synonym ? If it was under jdoe, the message is normal.

You should create the synonym under an another user or use a public synonym :
create public synonym test for jdoe.test; Received on Sun Oct 27 2002 - 00:40:53 CDT