Re: Stopping refresh of snapshots

Hi Chuck,

Did you try

        DROP SNAPSHOT <snapshot_name>;

Regards

Jerry

Chuck Hamilton wrote:
>
> 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.
 

-- 
Jerry Gitomer		Since I know how to spell DBA I became one. 
jgitomer_at_p3.net