Re: To modify the query of a Materialized View

  • From: David Aldridge <david@xxxxxxxxxxxxxxxxxx>
  • To: anuragdba@xxxxxxxxx
  • Date: 12 Sep 2006 08:55:15 -0700
  • Date: Tue, 12 Sep 2006 09:54:26 -0600

Drop and recreate -- if you created the MV on a prebuilt table then
you'll be able to keep the current data set. Otherwise, if you need the
current data set then copy it to a new table, drop the MV, rename the
new table back to the MV name and create the MV with the new query ON

Anurag Verma wrote:
Hi All,

How to modify the query of a materialized view?

Do we need to drop and recreate the mview ?

Or is there any ALTER statement to do this without dropping and recreating?

Thanks in advance,

-- //

Other related posts: