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.

No comments: