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

From: <karsten_schmidt8891_at_my-deja.com>
Date: Tue, 25 Jan 2000 12:36:48 GMT
Message-ID: <86k5d0$87u$1@nnrp1.deja.com>

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. Received on Tue Jan 25 2000 - 06:36:48 CST