Re: Oracle 8 and public synonyms

I am almost positive this is known bug with that version of sqlplus on NT.

Good Luck,

Robert Prendin

Kevin Barnes <kbarnes_at_airmail.net> wrote:

>I am experiencing a interesting effect with Oracle 8.04 under NT 4.0. I
>am unable to
>describe public synonyms created by sys or system from other users
>without specifiying
>the user name.
>
>example: As sys: create public synonym user_tables for user_tables;
>
>as user foo: describe user_tables --- no such object; desc
>sys.user_tables -- ok
>
>select * from user_tables --> works, I get my table list.
>
>create synonym user_tables for sys.user_tables ;
>desc user_tables === works fine...
>
>Anyone else experienced this?
>
>TIA,
>
>Kevin
>
>
Received on Wed Jun 03 1998 - 14:48:18 CDT