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.
Showing posts with label Materialized View. Show all posts
Showing posts with label Materialized View. Show all posts
Monday, April 20, 2009
Subscribe to:
Posts (Atom)