Showing posts with label Materialized View. Show all posts
Showing posts with label Materialized View. Show all posts

Monday, April 20, 2009

Oracle 10g materialized view bug, when using import fromuser , touser. ORA-00942

If you have materialized view, and importing using the option fromuser and touser , you may have the error below :-

BEGIN
dbms_mview.refresh('MV_TEST','C');
END;
*ERROR at line 1:ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429ORA-06512: at line 1

This is a bug in the oracle 10g, to workaround this recreate the materialized view.