ORA-12008

[engineer2100]

One of our packaged Procedures refreshing the Materialized Views fails with the following error

ERROR: -12008 - ORA-12008: error in materialized view refresh path
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist

When the refresh is made from outside of the package, the refresh runs to success.

Any ideas on why such a behaviour? And the strange this is that, we have 7 such Views, and only one such MV is causing this issue.

Thanks in advance...

-Engi

 

[SantaMufasa]

Engi,

Typically when you can successfully access a table or view under one circumstance but cannot under another circumstance is a permissions issue. Ensure that the owner of the stored procedure has explicit (not just "role membership" access permission) to the target object.

Let us know.


Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Turkbear]

Hi,
Does the Proc run as an account that has sufficient rights to access the underlying tables?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[engineer2100]

Thanks to both of you. I will find out the same and update you!!

-Engi