"Rick Denoire" <100.17706_at_germanynet.de> wrote in message
news:pmdoqv4u7pilc1t10u4d9rvfs8e4kjqqo6_at_4ax.com...
> Let's suppose I have a materialized view which:
> -must be refreshed with the method "complete" across a DB-link
> -is not updatable
> -will refresh using a cron job
>
> then, couldn't I accomplish the same using a regular table, which will
> be truncated and filled regularly with the same basic definition as
> the materialized view?
>
> Which would be the advantage of a materialized view in this case?
In Enterprise Edition query rewrite. In any edition it can be part of a
refresh group.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sat Nov 08 2003 - 09:00:24 CST
