Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with use of synonym command
Thanks for the insight. I appreciate it.
"Bruno Jargot" <see_at_reply.to.invalid> wrote in message
news:7vumrucmbu5v61ramo1e6rrk9ttm7aekdv_at_4ax.com...
> 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 - 09:46:10 CST