Re: ** MV questions
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- Date: Tue, 30 Oct 2007 13:52:23 -0700
On 10/30/07, Elliott, Patrick <patrick.elliott@xxxxxxxxxxxxx> 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
Other related posts:
