From: oracle_adam@nospam.com Newsgroups: comp.databases.oracle.server Subject: Re: Materialized Views: how do I refresh just a single partition? Date: 9 Sep 2002 15:04:17 GMT Organization: NewsOne.Net - Free Usenet News via the Web - http://newsone.net/ Lines: 37 Message-ID: References: <42ffa8fa.0209061748.2f7e269e@posting.google.com> <42ffa8fa.0209072204.786d22e0@posting.google.com> NNTP-Posting-Host: news.netmar.com X-Trace: news.netmar.com 1031583857 8728 205.139.138.14 (9 Sep 2002 15:04:17 GMT) X-Complaints-To: abuse@newsone.net NNTP-Posting-Date: 9 Sep 2002 15:04:17 GMT X-PNG: comp.databases.oracle.server X-MCC: jusungyang@yahoo.com X-NewsOnePostHost: 169.132.12.200 X-NewsOnePostAddr: 169.132.12.200 X-NOTrace: BHDKNKBKCLPCICJBJBILBJJJMKGDDPDBIBPL Thanks for your help! In article <42ffa8fa.0209072204.786d22e0@posting.google.com>, Jusung Yang 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" wrote in message news:... >> 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@newsone.net