| ORA-00942: table or view does not exist [message #125523] |
Mon, 27 June 2005 04:25  |
krishnavm
Messages: 5
Registered: June 2005
Location: India
|
Junior Member |
|
|
Hi....
I have installed Oracle database 9.2.0.1.0
After installation ...i tried to connect from
a java class using scott/tiger@oracle it was successfull
After that i created one user TEST with paasword TEST
in SYSTEM table space with temporary table space TEMP
and connected from sqlplus > conn test/test@oracle
and created a table tab_test
but this time when i tried to connect from java it shows
using test/test@oracle
##Error in executeQuery :oracle :ORA-00942: table or view does not exist###
what would be the reason ...please help me solving this problem
Also i tred to create another TABLESPACE and create a user in that
tablespace ...still the same problem
thanks for the same
Krishna
|
|
|
|
|
|
|
|
| Re: ORA-00942: table or view does not exist [message #125600 is a reply to message #125585] |
Tue, 28 June 2005 00:04  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi Satish
A user has got al privileges on objects created in its schema.. so as mentioned by Krishna, that he created table tab_test under user test, all privileges on this table tab_test are available with user test.
Thus whatever u said in this case is not applicable.
| Quote: |
The user Test does not have the required privileges on the tables...grant select , insert & update on the tables to user Test...
Thanks
Satish
|
The only scenario when this error can come is when the sql query is accessing any non-existent object. Let Krishna check the actual query that is getting executed.
Regds
Girish
|
|
|
|
|
|
| Re: ORA-00942: table or view does not exist [message #125611 is a reply to message #125606] |
Tue, 28 June 2005 01:06 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI Krishna
Below is the description of this error:
ORA-00942: table or view does not exist
Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.
Action: 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.
Contact the database administrator if the table needs to be created or if user or application privileges are 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.
On basis of this, first do check what SQL statement is getting you this error, then match the objects accessed in that SQL statement ith the ones already existent under that user.
Regds
Girish
|
|
|
|
|
|
|
|
|
|
| Re: ORA-00942: table or view does not exist [message #125629 is a reply to message #125627] |
Tue, 28 June 2005 01:59 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Sorry seems stupid to ask...
but hey, in the java program are you using connect string scott/tiger@oracle only for connecting to database?
Actually this is to make sure that program is connecting to this database only, in which you are making changes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
(