Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?

Re: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 28 Nov 2006 13:24:41 -0800
Message-ID: <bf46380611281324s23b0b55dica62e29107ee5337@mail.gmail.com>


On 11/28/06, Freeman, Donald <dofreeman_at_state.pa.us> wrote:
>
> I was just planning on running create or replace mview as select * from
> source;
>
>

create or replace materialized view?

That works on view, but not on MV's.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 28 2006 - 15:24:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US