Re: SQL plus memory exception

All

I've noticed that, this problem is for some synonyms and for some users ( not for all), So I've dropped all the public synonyms and recreated that synonyms. Now I'm not getting that error.

Can anyone tell me what's behind this.

Shafeek Khalidh

"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message news:atq37k$1k59t$1_at_ID-137434.news.dfncis.de...
> Hi
>
> I'm working on Oracle 8i on Windows 2000 server.
>
>
> "Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
> news:u65tr1mox.fsf_at_standardandpoors.com...
> > On Wed, 18 Dec 2002, itsprobablyme_at_msn.com wrote:
> > > Hi
> > >
> > > I've a table named MAIN under the user ADMIN. I've created a
> > > public synonym with the name MAIN.
> > >
> > > Now I've created another user called WUSER. I've given the
> > > privilages to WUSER on the table MAIN.
> > >
> > > But when I'm DESCRIBING the MAIN table from WUSER, it is
> > > showing a memory error and closes the sql plus.
> >
> > I did those exact steps on W2Kserver running 9i and had no
> > issue.
> > --
> > Galen Boyer
>
>
Received on Wed Dec 18 2002 - 09:16:24 CST