Home » Server Options » Replication » refresh rate of materialized view
refresh rate of materialized view [message #190043] Tue, 29 August 2006 02:20 Go to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi All,
I have a materialized view with refresh rate like this
CREATE MATERIALIZED VIEW MV_TEST
REFRESH FORCE
START WITH SYSDATE
NEXT SYSDATE + 1/24
AS
SELECT * fROM View_TEST


1)Does this mean that the materialized view would be refreshed every hour?

2)If it refreshes every hour what would be starting point time?

3)What if the database is unavailable/down at the time of next refresh time? Does it refresh immediately after the database becomes available?

Pls help me in understanding these. I am quite new to the concept of materialized view.

Thanks in advance.
Anand
Re: refresh rate of materialized view [message #190087 is a reply to message #190043] Tue, 29 August 2006 04:34 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
1. Yes - SYSDATE + 1/24 = every hour

2. SYSDATE - the time you run the command.

3. Yes
Previous Topic: Hanging Job - How to solve
Next Topic: EM does not show advanced replication
Goto Forum:
  


Current Time: Thu Mar 28 19:08:46 CDT 2024