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

Thanks for your help!

In article <42ffa8fa.0209072204.786d22e0_at_posting.google.com>, Jusung Yang <jusungyang_at_yahoo.com> writes:
>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
>>
>>

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net