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: Simple Snapshots

Re: Simple Snapshots

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 16 Dec 1999 18:37:00 GMT
Message-ID: <385930f9.169706784@news.earthlink.net>


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 email

Received on Thu Dec 16 1999 - 12:37:00 CST

Original text of this message

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