Re: Materialized view auto refresh not working

Hi

Had a problem with replication not automatically refreshing with 9i. Used the obsolete parameter job_queue_process=4 and it all worked fine!

Alistair

"Asif Kazi" <asifkazi_at_my-deja.com> wrote in message news:bc8c7120.0208210212.51b6db28_at_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 - 10:29:17 CDT