Re: To modify the query of a Materialized View

  • From: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
  • To: anuragdba@xxxxxxxxx
  • Date: Tue, 12 Sep 2006 17:55:01 +0200

Answers inline

On 9/12/06, Anurag Verma <anuragdba@xxxxxxxxx> wrote:

Hi All,


How to modify the query of a materialized view?


you can't

Do we need to drop and recreate the mview ?


yes

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


No

Thanks in advance,
Anurag



Other related posts: