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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 13 Feb 2004 14:14:34 +0100
Message-ID: <c0ihvr$9hk$1@news2.tilbu1.nb.home.nl>


Matthieu Exbrayat wrote:
> 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
Need a db link, need a job (on the MV side, iirc), and need to have job_processes on the remote site...

-- 

Regards,
Frank van Bortel
Received on Fri Feb 13 2004 - 07:14:34 CST

Original text of this message

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