On 10/30/07, Elliott, Patrick <patrick.elliott_at_medtronic.com> wrote:
>
> Here is an example showing how to update a materialized view using
> exchange partition. The catch to this is you will need to rebuild indexes
> afterwards, and I believe the materialized view itself will be STALE.
>
>
In addition, if the MV is built with the PREBUILT TABLE clause, dropping the
MV
leaves the MV intact.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 30 2007 - 15:52:23 CDT
