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

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

"Jusung Yang" <jusungyang_at_yahoo.com> wrote in message news:42ffa8fa.0209061748.2f7e269e_at_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
 eb -----
> > 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 Sat Sep 07 2002 - 06:02:10 CDT