| table or view does not exist [message #373315] |
Wed, 11 April 2001 06:53  |
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!!
|
|
|
|
| Re: table or view does not exist [message #373345 is a reply to message #373315] |
Wed, 11 April 2001 20:05  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
