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

References:

Re: ** MV questions
From: A Joshi

Re: ** MV questions
From: A Joshi

RE: ** MV questions
From: Elliott, Patrick

Re: ** MV questions

Other related posts: