Re: Question re basic replication

From: Ingo Peters <ipeters_at_yahoo.com>
Date: Thu, 24 Feb 2005 19:46:21 -0600
Message-ID: <gIOdnehyzITwHoPfRVn-jA@rogers.com>

On 2005-02-23, Frank van Bortel <fvanbortel_at_netscape.net> wrote:
> Well... sort of - refreshes get initiated from the snapshot
> sites.
> There is no need for a refresh group (though is does make life
> easier), nor for a job; you can do it manually, from the snapshot
> sites.
> What requirement is there that forces you to initiate refreshes
> from the master site?

You're right to ask the question about the underlying requirement. But, supposing that the requirement is uncircumventable, or at least not implementable in another way, Tom Kyte has a good suggestion for refreshing remote materialized views, which is very similar to what you're trying to do. He suggests scheduling a refresh using dbms_job on the remote machine. Check this out:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:362818006460

It's the June 11, 2004 posting.

HTH, Ingo Received on Thu Feb 24 2005 - 19:46:21 CST