Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question- SQL*Plus does not DESCribe
A copy of this was sent to AdrianLungu_at_EasyInternet.ca (Adrian Lungu)
(if that email address didn't require changing)
On Fri, 29 May 1998 00:54:42 GMT, you wrote:
>I am having a problem with SQL*Plus 8.0.3 on Windows95.
>
>A DESCribe on any data dictionary view returns the error:
>
> ORA -04043 Object does not exist.
>
>A select on the same DD view succeeds.
>This happens in any schema, SYS, SYSTEM included.
>User generated tables can be described.
>
>When running SQL*Plus 3.3 from the same machine, against the same schema, it
>describes the view OK.
>
>Server : Win NT 4.0
>Db : Oracle Enterprise 8.0.3 typical install
>Starter database - Typical install , ORCL, files copied from CD.
>Since the database is created automatically, the data dictionary creation
>scripts are run also automatically.
>
>Any help would be greatly appreciated.
>
Its a sqlplus 8.0.3 issue. Sqlplus cannot describe through synonyms. Its fixed in 8.0.4. The workaround is to describe this way:
SQL> desc sys.user_objects
You can describe the view SYS.user_objects but not the synonyms user_objects.
>
>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 Thu May 28 1998 - 20:30:00 CDT