Re: help me to refresh materialized view

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 31 Mar 2003 20:07:17 +0100
Message-ID: <3e894127_3@mk-nntp-1.news.uk.worldonline.com>

"Bernard Situmeang / Martine Verkade" <bermar_at_wanadoo.nl> wrote in message news:Kw%ha.220574$dW6.7503640_at_pollux.casema.net...
> Hi,
>
> I have created a materialized view mv_adong at database A in server A.
> The master tables is tbl_adong in database B in server B.
> I already did the select , delete, update statement on master table
> tbl_adong.
> Question:
> Is it possible if i login in server B to refresh the materialized view
> mv_adong in A ?
>

For the time being at least, please regard refreshing mviews as a 'pull', not a 'push'.
Log into A and look at dbms_snapshot.refresh.

Regards,
Paul Received on Mon Mar 31 2003 - 13:07:17 CST