Oracle Database Discussions

Hi all,
i'm developing an ODS system for MIS reporting where i'm creating materialized views for fast refresh.
Earlier everything worked fine.
1.) i created materialized view log in master site
2.) created materialized view in target site.
3.) refreshed fast in target.

but when i tried implementing the same script for other list of tables, it is giving me the error:



STEPS:
1.)CREATE MATERIALIZED VIEW LOG ON ARBOR.ACCOUNT_CATEGORY_VALUES
NOCACHE WITH PRIMARY KEY
INCLUDING NEW VALUES;

2.)CREATE MATERIALIZED VIEW POSCS1.MV_ACCOUNT_CATEGORY_VALUES
NOCACHE
ENABLE ROW MOVEMENT
NOLOGGING
NOCOMPRESS
PARALLEL(DEGREE DEFAULT INSTANCES DEFAULT)
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY
ENABLE QUERY REWRITE
AS
SELECT * FROM ACCOUNT_CATEGORY_VALUES@ARBOR;

3.)
12:00:07 TEST orcl >EXECUTE DBMS_MVIEW.REFRESH('MV_ACCOUNT_CATEGORY_VALUES','F')
BEGIN DBMS_MVIEW.REFRESH('MV_ACCOUNT_CATEGORY_VALUES','F'); END;

*
ERROR at line 1:
ORA-12018: following error encountered during code generation for
"TEST"."MV_ACCOUNT_CATEGORY_VALUES"
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1


Can anyone please tell me that why i'm getting this error? Whatever materialized views i've created before, i'm able to
do fast refresh but when i'm dropping them and recreating it, i'm getting the same ORA-00942 error