Database DataWarehousing (MOSC)

MOSC Banner

MV refresh Error...

edited Apr 23, 2010 12:59AM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi,
Suddenly , following statement started giving us the problem :

BEGIN
DBMS_MVIEW.REFRESH('COM_CUST_TOP_PARENT_MV','?','',TRUE,FALSE,0,1,0,FALSE);
END;

We get the following error message:

ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 2

This MV view is based upon joining a view and table. I verified that view is involved in MV is valid and 'MV query' itself returns the data , when run from sql prompt.
I am planning to put trace on(ALTER SESSION SET SQL_TRACE = TRUE;) , but in the mean-time any guess ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center