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,
Anurag

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006