DESCRIBE and HELP in SQLPLUS

From: Lynux <lynux_at_netvigator.com>
Date: 6 Feb 2000 14:07:56 GMT
Message-ID: <87jv7s$29m2@imsp212.netvigator.com>

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 Sun Feb 06 2000 - 08:07:56 CST