Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple Snapshots
You forgot to set JOB_QUEUE_PROCESSES to more then 0.
RTFM.
On Wed, 15 Dec 1999 09:30:24 +0800, "Grant Eggleton"
<grant.eggleton_at_isspl.com.au> wrote:
>I have had this problem for a while and cannot sort it out.
>I have a snapshot log created on a remote instance with a local snapshot
>being created for that referenced table (SELECT *). The snapshot is being
>created and uses a FAST refresh method with INITIAL set to sysdate and NEXT
>set to SYSDATE + 5/(60*24)
>
>The thing is that the snapshot view is being created and works fine,
>although it never refreshes, does anyone have any suggestions.
>
>
>
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Thu Dec 16 1999 - 12:37:00 CST