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

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