Re: Snapshot problem

Hi.
  Look to the JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL parameters from your init.ora config file( you can also find them described in Oracle Reference in documentation ). You have to set JOB_QUEUE_PROCESSES to a value of 1 or higher to get your snapshot refreshed.
  Hope this helps.

      Iustin Amihaesei

"gargantua" <Gargantua_at_hotmail.com> wrote in message news:<9t2nbb$dfm$1_at_garrison.globalnet.hr>...
> "gargantua" <Gargantua_at_hotmail.com> wrote in message
> news:9t2mvk$dfb$1_at_garrison.globalnet.hr...
>
> I'm sorry because of problem with sending previous post. I will continue
> now.
>
> > Even simply snapshot like:
> > CREATE SNAPSHOT snapshot1
> > REFRESH START WITH SYSDATE
> > NEXT SYSDATE + 5/1440
> AS SELECT * FROM table1;
>
> Oracle create SNAPSHOT, but newer refresh it.
> Where I making mistake?
>
> Thanks.
Received on Sat Nov 17 2001 - 13:46:05 CET