Re: The SNAPSHOT dose't refreshe automatically

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Wed, 20 Jan 1999 23:57:41 GMT
Message-ID: <36a66d0a.941145956@news.cyberus.ca>

Perhaps you've over-looked the init<sid>.ora parameters such as .. snapshot_refresh_processes

Robert Prendin

Mark Sorkin <msorkin_at_protectair.com> wrote:

>Hi all,
>
>I created following SNAPSHOT that should refreshe automatically every 5
>min., but it dose not:
>
>CREATE SNAPSHOT EMISSION_RESULT_SNAP
>REFRESH FAST
>START WITH sysdate NEXT sysdate + 5/1440
>AS SELECT * FROM ONTETESTOWNER.EMISSION_RESULT;
>
>What is wrong???
>
>Please help
>Thanks in your advance
>

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Wed Jan 20 1999 - 17:57:41 CST