Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus 8.0 does not DESCribe synonyms (but it does tables)...
A copy of this was sent to AdrianLungu_at_EasyInternet.ca (Adrian Lungu)
(if that email address didn't require changing)
On Mon, 25 May 1998 00:56:44 GMT, you wrote:
>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
>
It's a sqlplus/8.0.3 issue, fixed in 8.0.4 (already out there). sqlplus has problems describing synonyms (cat is a synonym for sys.cat, if you desc sys.cat it'll work)
>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
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun May 24 1998 - 20:34:10 CDT