To modify the query of a Materialized View

  • From: "Anurag Verma" <anuragdba@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 12 Sep 2006 10:47:23 -0500

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: