MV refresh Error...
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 ?
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 ?
0