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

From: "Chris Marquez" <marquezemail@xxxxxxxxx>
To: oracle-l <Oracle-L@xxxxxxxxxxxxx>
Date: Tue, 28 Nov 2006 12:05:41 -0500

Modify Snapshot without drop

RH Linux
9.2.0.5

I need to alter my base table (add columns) and thus also the remote db
MView referring to it.

I don't mind doing some RTFM and I have been on Metalink this morning
without much luck.

I have some old notes / docs on how to do this "unsupported" (8i days,
updating intern tables) and how to do this if the MView is ON PREBUILT, but
mine is not.

I'm looking for good references or HOWTO's if someone has some, or even save
me some time and let me know if this can be done at all…with supported SQL
syntax?

Sometimes proving something is not supported is harder than proving it is.

Hmm, the more I think about it, I'm also assuming that I can use the
existing MLog on the base table after I alter the base table…not sure this
is a correct assumption?

Thanks,

--
Chris Marquez
Oracle DBA

Follow-Ups:
- Re: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?
  - From: Jared Still
- Re: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?
  - From: Alberto Dell'Era

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

Other related posts: