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
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
Comment