Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping refresh of snapshots
I don't know of a way to turn off the automatic refresh, but you could alter
the snapshot and set the 'START WITH' parameter of the REFRESH option to a
date in the distant future.
Chuck Hamilton wrote in message <3507a5d6.6582745_at_news.dvol.com>...
>We have a bunch of snapshots that were created with the automatic
>refresh parameters (START WITH and NEXT). I no longer want them to
>automatically refresh. Is there some way to convert them to manually
>refreshed snapshots without recreating them? The only solution I've
>come up with is to set JOB_QUEUE_PROCESSES=0, but that stops *all*
>jobs from running which isn't what I want. Is there some other way to
>do it?
>
>Thanks in advance for your help.
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>If at first you don't succeed, sky diving isn't for you.
Received on Wed Mar 11 1998 - 00:00:00 CST