automatic refresh of materialized view does not work

[Matthieu Exbrayat]

Hie all,

I am currently using materialized views within Oracle 9i.

For instance I create mv1 on DB bddist2, as a snapshot of sur1 on bddist1 :

SQLcreate materialized view mv1
2 refresh force
3 start with sysdate
4 next sysdate+1/(24*60)
5 as
6 select * from sur1@bddist1;

I manage to create the materialized view, refresh it manually using "dbms_snapshot. refresh",
but automatic refresh does not work (it never occurs).

I created a master site repadmin and a mat. view site mvadmin using the wizard.
I use a private DB link for my user.
I create the snapshot using this user's account.
JOB_QUEUE_PROCE SSES is set to 10

Any idea ?

Thanks for help



Matthieu EXBRAYAT

[Matthieu Exbrayat]

Re: automatic refresh of materialized view does not work

To give some more details :
When my materialized view and master table are on the same database, it works fine.
The problem arises when they are on two different databases...

M. EXBRAYAT