XPost: comp.databases.oracle.misc   
   From: exbrayat@univ-orleans.fr   
      
   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 :   
      
   SQL> create 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_PROCESSES is set to 10   
      
   Any idea ?   
      
   Thanks for help   
      
      
      
   Matthieu EXBRAYAT   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)