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 -> The SNAPSHOT dose't refreshe automatically

The SNAPSHOT dose't refreshe automatically

From: Mark Sorkin <msorkin_at_protectair.com>
Date: Wed, 20 Jan 1999 04:36:02 -0500
Message-ID: <36A5A382.9CDC3768@protectair.com> 





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

Received on Wed Jan 20 1999 - 03:36:02 CST












Original text of this message













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