Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DESCRIBE and HELP in SQLPLUS

Re: DESCRIBE and HELP in SQLPLUS

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 07 Feb 2000 10:29:42 -0800
Message-ID: <389F0F16.49D70AA2@us.oracle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US