Re: Question re basic replication

Why do I want to initiate the refresh from the master site?

Bascically because there will be a person at the master site who is responsible for the data in the master tables. They would like to be able to update the master tables and test the application before explicitly releasing the updated tables to the snapshot sites.

John

Ingo Peters <ipeters_at_yahoo.com> wrote in message news:<gIOdnehyzITwHoPfRVn-jA_at_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 Tue Mar 01 2005 - 03:01:56 CST