Re: How to automatically Refresh snapshots ?

From: ykhogaly <ykhogaly_at_us.oracle.com>
Date: Thu, 23 Dec 1999 21:03:18 -0700
Message-ID: <83uo0q$30p$1@inet16.us.oracle.com>

Also you may want to try this which is from replication manager!

begin
dbms_refresh.change( name = '"XXX"."YYYYY"', next_date = to_date('26.12.1999 15:23:03', 'DD.MM.YYYY HH24:MI:SS'), interval ='sysdate + 1', implicit_destroy = FALSE, rollback_seg = '', push_deferred_rpc = TRUE, refresh_after_errors = TRUE); end;

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

"Xavier Darcos" <xdarcos_at_astek.fr> wrote in message news:386240C1.6C89505B_at_astek.fr...
> Hi,
>
> I've created a refresh group (following the advice of Lars Bo vanting)
> to refresh my snapshots on a remote database.
>
> But when I use the following :
>
> DBMS_REFRESH.CHANGE('MyRefreshGroup',Sysdate,NULL) to force the refresh,
> it doesn't refresh my snapshots.
>
> Even when I created the refresh group with the interval "Sysdate +
> 1/48", half an hour later, my snapshots were not refreshed.
>
> So, How ?
>
> Thanks a lot
>
> Xavier
Received on Thu Dec 23 1999 - 22:03:18 CST