Re: Simple Snapshots

From: <ngreene_at_my-deja.com>
Date: Thu, 16 Dec 1999 20:25:23 GMT
Message-ID: <83bhre$fe3$1@nnrp1.deja.com>

In article <3856f04e.0_at_news.highway1.com.au>, "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.

I am experiencing the same problem under 8.0.5.1. I have not seen anyone post a fix for this and Oracle hasn't provided us with a solution either. Anyone corrected this, aside from writing your own dbms_job to handle the refreshes?

--
Neil Greene
Earthlink Network
email: ngreene_at_my-deja.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 16 1999 - 14:25:23 CST