Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: automatic refresh of materialized view does not work

Re: automatic refresh of materialized view does not work

From: Matthieu Exbrayat <exbrayat_at_univ-orleans.fr>
Date: Fri, 13 Feb 2004 14:26:11 +0100
Message-ID: <c0ij9v$1an0$1@vishnu.jussieu.fr>


Frank van Bortel wrote:

> Need a db link, need a job (on the MV side, iirc), and
> need to have job_processes on the remote site...

DB LINK exists
job_processes is set to 10 on both sites. Should be enough...

probably the job is missing. How should I set it ? Received on Fri Feb 13 2004 - 07:26:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US