Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question re basic replication
John Leslie wrote:
> So I can run the refresh command on the remote machine over the DBlink?
>
> JOhn
>
>
>
> Ingo Peters <ipeters_at_yahoo.com> wrote in message news:<Ioudnb28h4uFYYbfRVn-jw_at_rogers.com>...
>
>>On 2005-02-22, John Leslie <johnleslie_at_madasafish.com> wrote: >> >>>I want to replicate some tables to 2 other databases, but I would like >>>the refresh to be initiated by some user written code at the the >>>master site. Is this possible? As far as I can see the refresh groups >>>run on the snapshot sites at some pre-configured interval. >> >>There is a manual refresh option available. I'd be quite surprised if >>the Oracle docs didn't talk about this. Have you checked? >> >>Ingo
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?
-- Regards, Frank van BortelReceived on Wed Feb 23 2005 - 14:00:31 CST