Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,647
    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.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  3. #3
    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

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,647
    >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.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  5. #5
    Join Date
    Mar 2011
    Posts
    6
    this problem appeared on 11g only

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,647
    >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.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  7. #7
    Join Date
    Mar 2011
    Posts
    6
    thanks alot anacedent

  8. #8
    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.

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,647
    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.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  10. #10
    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.

  11. #11
    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.

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,647
    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.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  13. #13
    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

  14. #14
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,434
    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.

  15. #15
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •