| ORA-00942: table or view does not exist when table exists [message #62830] |
Tue, 17 August 2004 23:03  |
shyam
Messages: 25
Registered: January 2001
|
Junior Member |
|
|
when i am exporting the schema or full database
the logfiles shows the table below exporting with
10000 rows but when i am trying to query this one i am getting the error
SQL> select count(*) from CARGORevenueFeb2004;
select count(*) from CARGORevenueFeb2004
*
ERROR at line 1:
ORA-00942: table or view does not exist
when i am querying the views like dba,all,user_tables
i am getting this table name.what exactly happening.
normally i am not able to select or describing this table
how to solve this
|
|
|
|
| Re: ORA-00942: table or view does not exist when table exists [message #62831 is a reply to message #62830] |
Wed, 18 August 2004 01:22  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
It seems that you are not quering the table from the user who owns that table. Check it using following query :
select table_name,owner from dba_tables where table_name='CARGOREVENUEFEB2004';
Be sure that u have logged in using the same id who is the owner of this table. And if you are not the owner but have privileges to access this table so use appropriate schema name with table name to access it like :
select * from another_user.CARGORevenueFeb2004;
Daljit Singh
|
|
|
|
|
|
| Re: ORA-00942: table or view does not exist when table exists [message #62856 is a reply to message #62831] |
Thu, 19 August 2004 22:20 |
shyam
Messages: 25
Registered: January 2001
|
Junior Member |
|
|
but when i am exporting this table is
exporting from the same schema.When i am connecting to that schemas and selecting from user__Tables
this table name is comming and that means the datadictionary entry for this table for the current schema i logged.There is an entry in data dictionary
but why i am getting this erorr.
so again i have to select privileges for the table to the schema
|
|
|
|
| Re: ORA-00942: table or view does not exist when table exists [message #62871 is a reply to message #62830] |
Fri, 20 August 2004 20:42 |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
Hi Shyam
it appears that you have the Export permission for the database so you are able to see that the table names run on the screen and "CARGORevenueFeb2004" is one such table whose name u see but cant access.
if you are a dba then
access the table with the schema name
like "ownername.CARGORevenueFeb2004"
this will work
or else
ask the owner to give you select on the table so that you are able to read data
inthis case also you must access the table using the
"ownername.CARGORevenueFeb2004"
with best wishes
balaji
|
|
|
|
|
|
| Re: ORA-00942: table or view does not exist when table exists [message #63370 is a reply to message #62871] |
Wed, 29 September 2004 23:27 |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
Hi balaji,
You are right in saying that if you are not owner of the schema, then you can make select query(or any other) using owner.table_name. But I am little bit confused because on some instance I am able to access other users table without prefix of owner name. I am having same type(same char set) of instances. I imported same database to both instances using same procedures. On one instance I am not able to select with owner name but on other without owner name. So what can be the reason?
Thanks,
Ravi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
