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;
|
|
|