SQL & PL/SQL

Hi Friends,

I have Created one Materialized view refresh on demand.

Create Materialized view temp_mv......refresh force on demand....(select * from A,B).

now i m refreshing this MV from the procedure using this statement..

dbms_mview.REFRESH ('temp_mv', 'C');

it gives error

ORA-00942 ORA-00942: table or view does not exist
ORA-01403 ORA-01403: no data found


This procedure works fine if i drop and recreate the Materialized view and execute procedure again.
I have analysis that it gives error when table A or table B drop and recreate this error happen...otherwise
it wont make problem to refresh the Materialized View.
so my question is
1) Only this reason gives error like that.
2) Materialized View created on demand that time base table recreate it
wont be refresh using this
dbms_mview.REFRESH ('temp_mv', 'C');

Please Reply me.
Thanks.