Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping refresh of snapshots

Re: Stopping refresh of snapshots

From: C. Mason <cmason_at_aai.arco.com>
Date: 1998/03/11
Message-ID: <Epo64H.B56@news.arco.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US