Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to automatically Refresh snapshots ?
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