Home » RDBMS Server » Server Administration » Table or view does not exist (Oracle 9i Windows XP)
Table or view does not exist [message #343716] Wed, 27 August 2008 22:29 Go to next message
ram_royalece@yahoo.co.in
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
When i try the following queries,

select * from database_properties;


select * from dba_tablespaces;

It throws an error msg. ORA-00942 table or view does not exist. Not only these queries. It throws the same error for most of the views.

WHy does it happen? Pls do reply...
Re: Table or view does not exist [message #343717 is a reply to message #343716] Wed, 27 August 2008 22:33 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>WHy does it happen?
I do not know which user you are logged in as;
but who ever it is, this schema does not have an object by the name of DBA_TABLESPACES
Re: Table or view does not exist [message #343720 is a reply to message #343716] Wed, 27 August 2008 22:38 Go to previous messageGo to next message
ram_royalece@yahoo.co.in
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
Thanks for replying.

I logged in as sysdba...

Let us ignore dba_tablespaces. Why does it throw the same error for databse_properties. The same error happens for most of the views.

Pls do reply..

Re: Table or view does not exist [message #343721 is a reply to message #343716] Wed, 27 August 2008 22:40 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

See previous response.

Your answers can be found by Reading The Fine Manuals found at
http://tahiti.oracle.com
Re: Table or view does not exist [message #343754 is a reply to message #343720] Thu, 28 August 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't execute catalog.sql.

Regards
Michel
Re: Table or view does not exist [message #343930 is a reply to message #343754] Thu, 28 August 2008 08:17 Go to previous message
ram_royalece@yahoo.co.in
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
Thanks a lot... I understood...
Previous Topic: ORA-07445: exception encountered
Next Topic: Old Tomcat inactive session in oracle 10g
Goto Forum:
  


Current Time: Wed Dec 07 18:37:30 CST 2016

Total time taken to generate the page: 0.09616 seconds