Jobs Not Populating Materialized Views

From: Pink Panther <PinkPanther2003_at_mail.com>
Date: 4 Feb 2004 21:24:32 +1100
Message-ID: <Xns9485D03B02673PinkPanther_at_203.134.67.67>


Hi All,

Sorry this may be a repost as first attempt died on me...

I have a set of 50 materialized views that are populated every morning.

However 2 of the materialized views contain no records (I know the master does contain records).

None of the jobs are broken and all run as scheduled.

When I use DBA Studio and goto the refresh groups and manually run the job (clicking the button 'manual refresh' or somesuch) hey presto the snapshot's populated. It 'disappears' the next morning.

The other oddity is that when I run the SQL to generate the materialized view in Free Toad no records are returned. However using SQL Plus the correct results set is returned (same user in both sessions). So I assume I've go the relevant permissions on the master tables.

Anyone got any pointers?

Regards,

Peter Received on Wed Feb 04 2004 - 11:24:32 CET

Original text of this message