Re: Materialized view auto refresh not working

In article <1029943758.21500.0.nnrp-07.3e311022_at_news.demon.co.uk>, "Alistair says...
>
>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

That's probably because JOB_QUEUE_PROCESSES is NOT obsolete. I think you're confusing that with _JOB_QUEUE_INTERVAL, which moved to an underscore parameter?

Pete
>
>"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
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Wed Aug 21 2002 - 12:33:24 CDT