Re: Advanced Materlized view is not updating data

On 7 Nov 2005 22:04:48 -0800, niraj.kumar.ait_at_gmail.com wrote:

>
>
> Hi,
>
> Materlized view is not updating data .For the first time
>is copies all the entries from table A to B( suppose i m replicating
>logs from A to B ) .I have configured it to update the data after 2
>minute but it is not working (dont give any error ) i.e it dont update
>data . When I configure it to update data after each commit it gives
>some error .
>
>with regards
>Niraj

you did

- make sure job_queue_interval is non-zero (ie 60)
- job_queue_processes is non-zero
- there actually is a job scheduled

--
Sybrand Bakker, Senior Oracle DBA