Materialized view not refreshing
Posted on 2004-10-29
Hi all Oracle guys,
I build a materalized view with refresh complete cause it is based on a complex view.
However, the view does not refreshes, I tried a very simple statement
CREATE MATERIALIZED VIEW MVW_BOM
START WITH TO_DATE('29-Oct-2004 04:25:00 PM','dd-Mon-yyyy HH:MI:SS AM')
NEXT SYSDATE + 1/240
WITH PRIMARY KEY
AS SELECT * FROM VW_PSG_BOMCHECK
The time on server when I created it was 4:22:18 PM, and I waited till 4:26:00 and the view was not refreshed.
However, If I tried it on another server, it does work well with the same sql, can anyone please tell me whether there is a setting in the DB server itself to control this.
Urgent as i have dial up to the company every day 8am :-(