Re: Materialized Views: how do I refresh just a single partition?

Well, this is somewhat different. You use materialized views with the hope of creating a automatic process that updates summarized data, mostly, for you. If you have to go down to the base table level and manually manage it as you would a regular partitioned table, it kind of defeats the purpose of creating a MV in the first place. If the MV can not be easily and automatically refreshed, what would be the use of it? The only thing I can think of is QUERY REWRITE, maybe.

The right questions to ask may be: how do I make my partitioned MV fast refreshable, or in the case of 9i, how do I make them PCT (partition change tracking) refreshable.

"Joe Sath" <dbadba62_at_hotmail.com> wrote in message news:<S0le9.5065$aG2.1140_at_nwrddc02.gnilink.net>...
> you can create the table first, and then create materialized view with the
> same name,
> on prebuilt table
> never refresh
> ......
>
> Then just the refresh the table as you normally do.
>
> Regards
>
>
Received on Sun Sep 08 2002 - 01:04:26 CDT