Re: Stopping refresh of snapshots

I had one that I wanted a procedure to control the refresh for and I set the NEXT_REFRESH (use DBMS_SNAPSHOT package) to sysdate + 9999. That keeps the auto refreshes out of your hair for a while.

On Wed, 11 Mar 1998 14:56:38 GMT, chuckh_at_dvol.com (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.
Received on Fri Mar 13 1998 - 00:00:00 CST