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 -> Question- SQL*Plus does not DESCribe

Question- SQL*Plus does not DESCribe

From: Adrian Lungu <AdrianLungu_at_EasyInternet.ca>
Date: Fri, 29 May 1998 00:54:42 GMT
Message-ID: <6kl1ei$ikc$1@nntp2.uunet.ca>


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.

Thank you,

Adrian Lungu Received on Thu May 28 1998 - 19:54:42 CDT

Original text of this message

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