Home » RDBMS Server » Server Administration » table or view does not exist
- table or view does not exist [message #373315] Wed, 11 April 2001 06:53 Go to next message
Timo Hansen
Messages: 1
Registered: April 2001
Junior Member
I am very new to Oracle. I only started working with Oracle about two weeks ago and I am strugeling! I am running Oracle 8.1.7 on Windows NT 4.0 workstation. I created a database and users. I can access the tables from within DBA Studio but as soon as I go to SQL*PLUS I cannot query any table. I can connect but as soon as I run a query it gives me the following error � �table or view does not exist�
I have also used another query builder program. This allows me to connect and view all the tables but I can still not query the database. Please Help!!

Report message to a moderator

- Re: table or view does not exist [message #373345 is a reply to message #373315] Wed, 11 April 2001 20:05 Go to previous message
Naresh Sharma
Messages: 12
Registered: April 2001
Junior Member
Check each of the following:

* The spelling of the table or view name.
* That a view is not specified where a table is
required.
* That an existing table or view name exists.

* Check that the user has the application
privileges as required to access the table.

* Also, if attempting to access a table or view
in another schema, make certain the correct
schema is referenced and that access to the
object is granted.

--------------------------------

HTH

Naresh

Report message to a moderator

Previous Topic: query
Next Topic: about '' and null
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 06 04:48:33 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.