RE: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>, "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 17:28:41 -0500
Yep, I believe you are right but I found a reference to that syntax
used by Arup Nanda on OTN <g>. I'm going to skip ahead just drop the mv
and rebuild in about five minutes.
-----Original Message-----
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Tuesday, November 28, 2006 4:25 PM
To: Freeman, Donald
Cc: marquezemail@xxxxxxxxx; oracle-l
Subject: Re: MODIFY Materialized View Definition without
dropping it (or the MLog) after base table alter?
On 11/28/06, Freeman, Donald <dofreeman@xxxxxxxxxxx> 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
Other related posts:
