Materialized view auto refresh not working

From: Asif Kazi <asifkazi_at_my-deja.com>
Date: 21 Aug 2002 03:12:49 -0700
Message-ID: <bc8c7120.0208210212.51b6db28@posting.google.com>

Hi,
I want to use the materialized view auto-refresh feature that oracle 9i provides.However it doesn't seem to be working. Any idea what the problem
could be .

My query is give below:

CREATE MATERIALIZED VIEW patient_mv
REFRESH COMPLETE START WITH to_date(to_Char(sysdate,'MM/DD/YYYY') || ' 12:00:00 PM','MM/DD/YYYY HH:MI:SS PM')
NEXT to_date(to_Char(sysdate,'MM/DD/YYYY') || ' 3:40:00 PM','MM/DD/YYYY HH:MI:SS PM')
AS
select pat.PATIENT_ID,pat.primary_provider from patient pat,

	 (select max(Date_time) date_time,patient_id
	 	 from patient_status_Change_history
	  where patient_status_id in (1,2)
	  group by patient_id) psch

where pat.patient_id = psch.patient_id Received on Wed Aug 21 2002 - 05:12:49 CDT