If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > ORA-00942: table or view does not exist

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 6
ORA-00942: table or view does not exist

hello ,
I work on oracle 11g R2 and i got error ORA-00942: table or view does not exist this error appear when execute procedure after few days from work on the schema and after grant table again it works for few days then it give me error again and so on i create cron job to grant this table daily but this is not a good solution i check oracle metalink but i didn't find anything related to this issue .

can anyone help me
thanks
yazan
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,611
GRANT do not spontaneously evaporate.
DBMS_LOGMNR can reveal who issues REVOKE.

Does this schema get dropped & recreated?
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 6
no one me can login to database and revoke it , i have many schemas and this behavior appear on all schams on the same table and randomly
and it is not drroped or recreated , i work on 10g for 4 years and i didn't see this behavior before
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,611
>i work on 10g for 4 years and i didn't see this behavior before
What has changed at about same time when bad behavior appeared?
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 6
this problem appeared on 11g only
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,611
>this problem appeared on 11g only
Then I suggest you submit a bug report to Oracle.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 6
thanks alot anacedent
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Jun 2011
Posts: 3
ORA-00942: table or view does not exist

yazan84,
Did you find a resolution to this problem? I am experiencing an identical issue. The error appears randomly on multiple schemas within my DB and also occurs on a different table or view.
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,611
Quote:
Originally Posted by bpino View Post
yazan84,
Did you find a resolution to this problem? I am experiencing an identical issue. The error appears randomly on multiple schemas within my DB and also occurs on a different table or view.
Software never behaves randomly.
Without additional details, please enjoy your mystery.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
Join Date: Jun 2011
Posts: 3
Backstory - The application previously ran on Oracle 10.2. In our latest release, we upgraded to Oracle 11.2.0.1.0 and since this the upgrade we have encountered this error 6 times.

The Issue - In our production environment, without warning, the application will begin to throw errors because of failing Oracle stored procedures (SP) even though these same SPs were previously working correctly. After review of our database error table we see the following error logged:

ORA-00942: table or view does not exist

Normally, this would be one of the more intuitive Oracle error messages to understand, however, in this case it is just plain not correct. We have decomposed the stored procedures and ensured that every possible query within the SP is valid and returns a result set. However, when the SP is called by the application, the error is again generated. We have found that rebooting the database clears the issue and that things begin to work again with no other corrective action.

Below is a link to a post where someone explains similar behavior, but no resolution is provided:
OTN Discussion Forums : ORA-00942 - intermittent....under load? ...

If there is additional information that will help, please let me know.
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Jun 2011
Posts: 3
As a resolution to the issue once it occurs, we have found that taking a backup and immediately restoring that backup resolves the issue.
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,611
Quote:
Originally Posted by bpino View Post
As a resolution to the issue once it occurs, we have found that taking a backup and immediately restoring that backup resolves the issue.
Post hoc ergo propter hoc - Wikipedia, the free encyclopedia

I very well could be 100% mistaken.
Remember that privileges acquired via ROLE do not apply within named PL/SQL procedures.
The ORA-00942 can occur when invoker does not have direct privileges on underlying table.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 6
Dear ,
I opened SAR with oracle support and still this problem didn't solve yet they said thats bug in 11.2.0.1 and it resolved on the 11.2.0.2 and as they said it is related to timestap with sheard pool once i get any new updates i will share it for all .
Regards
Reply With Quote
  #14 (permalink)  
Old
Lead Application Develope
 
Join Date: Jun 2004
Location: Liverpool, NY USA
Posts: 2,416
Have your dba install 11.2.0.2
__________________
Bill
You do not need a parachute to skydive. You only need a parachute to skydive twice.
Reply With Quote
  #15 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 6
I tried to install 11.2.0.2 on our envarument but it is faild i use oracle RAC with HP Itanium server , the problem was oracle can't see the SAN disks so i can't create the Database so i install 11.2.0.1 and it is installed without any problem
Regards
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On