Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized Views: how do I refresh just a single partition?

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

From: Jusung Yang <jusungyang_at_yahoo.com>
Date: 6 Sep 2002 18:48:46 -0700
Message-ID: <42ffa8fa.0209061748.2f7e269e@posting.google.com>

  1. Don't think you can do that. Not even with 9i. You only have 3 choices in the REFRESH clause of the MV : FAST, COMPLETE and FORCE. You also can not issue the other partition related commands such as DROP, EXCHANGE, TRUNCATE on partitioned materialized views.
  2. For the index created internally by ORACLE, the I_SNAP$_<MVname>, you can only specify the storage by using the USING INDEX clause. Other indexes you wish to create, you create them normally as you would with tables.

oracle_adam_at_nospam.com wrote in message news:<alal43$hng$1_at_news.netmar.com>...
> Greetings -
>
> I am building my first materialized view in 8.1.7.3 and have 2 questions:
>
> 1) If I build the mv with partitions, is it possible to refresh only certain
> partitions (for example, last month's partition) and NOT refresh the other
> partitions? What would be the PL/SQL syntax?
>
> 2) How do I specify that the mv create indexes on specific columns?
>
> many thanks,
> AK
>
> ----- 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
Received on Fri Sep 06 2002 - 20:48:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US