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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment