SQL*Plus 8.0 does not DESCribe tables

From: Adrian Lungu <AdrianLungu_at_EasyInternet.ca>
Date: Mon, 25 May 1998 00:56:44 GMT
Message-ID: <6kag27$oal$1@nntp3.uunet.ca>

I have the following problem:

Oracle Enterprise 8.0.3 on NT4

Typical installation for a starter database Oracle 8 clients on Win 95 ( SQL*Plus 8.0) Oracle 7 clients on Win 95 ( SQL*Plus 3.3)

From the same client machine, logging on to the same schema (e.g. SYSTEM) with both versions of SQL*Plus, v8.0 does nor DESCribe any data dictionary view ( e.g. CAT)

ORA - 04043 object cat does not exist

but can SELECT from it

On the same schema, the same view, 3.3 did successfully DESC it. ( i.e all the data dictionary is visible for describing, scripts have been run automatically by the installer)

on user-created tables DESC works with both versions.

Any suggestion to solve this would be much appreciated Thank you!

Adrian Lungu Received on Sun May 24 1998 - 19:56:44 CDT