Hi All,

I've reposted this as my original post never seemed to make it off my
local news server, so here goes Google...

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.

I've drop and recreated the snapshots with no luck.

Anyone got any pointers?

Regards,

Peter