Re: The DESCRIBE command in SLQ*PLUS, Wierd...

Karsten,

You are right! All the objects that I couldn't describe were public synonyms.

How would I do the owner.object? for example v$sqltext is a public synonym and as system user, I couldn't describe sys.v$sqltext (Assuming SYS was the owner of this synonym, unless I am wrong).

But If I try sys.v_$sqltext it is fine. Should I know what the underlying objects are for public synonyms in order for me to do this? Please advise!

Thanks much,
-Suresh

In article <86k5d0$87u$1_at_nnrp1.deja.com>,   karsten_schmidt8891_at_my-deja.com wrote:
> Hi,
> there used to be a bug in sqlplus 8.0.3, if i remember correctly.
> describe did not work with objects granted to public.
>
> use desc owner.object instead.
>
> this was fixed in the next release.
>
> Karsten
>
> In article <86i71k$r8q$1_at_nnrp1.deja.com>,
> suchandr_at_my-deja.com wrote:
> > Does anyone know, why the DESCRIBE <objectName> would give
> > 'Object not found' error. But, the SELECT on the same object works
> fine.
> >
> > I explicitly checked the grants too...have SELECT privilege on all
of
> > them. This is happening for views defined on objects of other users.
> > Including USER_OBJECTS, USER_INDEXES, USER_TABLES etc...Any
clues?...
> >
> > Thanks,
> > -Suresh.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 10:04:02 CST