|MATERIALIZED VIEW Not refreshed [message #25336]
||Wed, 16 April 2003 03:49
Registered: August 1999
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 ?
CREATE MATERIALIZED VIEW Masking_day
USING INDEX TABLESPACE indx
REFRESH START WITH SYSDATE
GROUP BY Date_Day, StatusCodeFamily
ORDER BY Date_Day, StatusCodeFamily;