used by Arup Nanda on OTN . I'm going to skip ahead just drop the mv
and rebuild in about five minutes.
-----Original Message-----
From: Jared Still
Sent: Tuesday, November 28, 2006 4:25 PM
To: Freeman, Donald
Cc: marquezemail_at_gmail.com; oracle-l
Subject: Re: MODIFY Materialized View Definition without
dropping it (or the MLog) after base table alter?
On 11/28/06, Freeman, Donald 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