DESCRIBE

Prefix the tablename with the schema owner and the desc should work. It's just a pain considering as you say you have already created the synonyms and granted privs.

DESC "Schema"."Table" works for us on 8.0.4 while no prefix fails.

-----Original Message-----
From: Pete Sharman [mailto:psharman_at_us.oracle.com] Posted At: Monday, February 07, 2000 1:30 PM Posted To: server
Conversation: DESCRIBE and HELP in SQLPLUS Subject: Re: DESCRIBE and HELP in SQLPLUS

From memory, this is a known bug in 8.0.3. I don't know if there was a patch
for it, but if not you'll be told to upgrade since 8.0.3 is not supported any
longer.

HTH. Pete

Lynux wrote:

> Our Oracle version is 8.0.3. We find that we cannot use the DESCRIBE
> and HELP command to view objects with public synonym and select
granted.
> However, we can still select the content from it.
> For example,
>
> SQL> desc user_tables
> ORA-...: Table or view does not exist
>
> SQL> select table_name from user_tables;
>
> TABLE_NAME
> ----------------------------------
> TESTING
> ABC
>
> 2 row(s) selected
>
> Moreover, when using HELP function, it always state that:
>
> SQL> help alter database
> HELP not accessible.
>
> I have already import all the helptbl.sql helpindx.sql ... into
database.
> Is there any problem on my database? Actually, the functions are
> all ok in my Oracle 8.0.4.4 database.
>
> Thanks in Advance.
Received on Mon Feb 07 2000 - 13:21:22 CST