- 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.
- 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
