Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 - 12:29:42 CST