Home » Server Options » Replication » MATERIALIZED VIEW Not refreshed
MATERIALIZED VIEW Not refreshed [message #25336] Wed, 16 April 2003 03:49
Fred
Messages: 34
Registered: August 1999
Member
Hi,
I create a mv on a table. Data must be refreshed every quarter. I use a mv because response time is the primary problem of the application.
At creation, data are well created but automatic refresh doesn't work.
Dbms_refresh.refresh(masking_day) doesn't work too.
We use Oracle 8.1.7 on Solaris.

Where i'am wrong ?

fred

CREATE MATERIALIZED VIEW Masking_day
PCTFREE 0
TABLESPACE stat
USING INDEX TABLESPACE indx
REFRESH START WITH SYSDATE
NEXT SYSDATE+15/(60*24)
AS
SELECT
Date_Day,
StatusCodeFamily,
SUM(NbMaskRequest) NbMaskRequest
FROM Time_slot_masking
GROUP BY Date_Day, StatusCodeFamily
ORDER BY Date_Day, StatusCodeFamily;
Previous Topic: Application Gateway - OCN?
Next Topic: Errors when creating snapshot replication
Goto Forum:
  


Current Time: Thu Mar 28 14:23:36 CDT 2024