Re: Materialized View not automatically refreshing

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 10 Jul 2003 00:05:26 +0200
Message-ID: <sb4pgvsvg0lvl4i5apnn30nsree2rbjb51@4ax.com>

On Wed, 09 Jul 2003 21:19:09 +0000, JamesLane <JamesLane03_at_yahoo.com> wrote:

>I am using TOAD and under Jobs it lists the refresh to occur every hour,
>but when the time comes... and passes... nothing happens. The job does
>not update either.
>
>Thank you for any help

Sorry to ask, but you did make sure your job_queue_processes parameter is nonzero prior to creating the mv?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 09 2003 - 17:05:26 CDT