Re: how are the snapshots refreshed ?

[claudio cutelli]

you should define the interval in the snapshot's DDL.  ES. START WITH sysdate  NEXT sysdate + (1/24)/30 ----- Original Message ----- From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 1:58 PM Subject: how are the snapshots refreshed ? Dear Gurus,   I have made 10 tables as snapshots . And I want to refresh them for specific intervals. How can I do that ; I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but could not succeed . How is it done ? Bunyamin