FAQ
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

Search Discussions

  • Ghassan Salem at Sep 12, 2006 at 3:55 pm
    Answers inline
    On 9/12/06, Anurag Verma 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,

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 12, '06 at 3:47p
activeSep 12, '06 at 3:55p
posts2
users2
websiteoracle.com

2 users in discussion

Anurag Verma: 1 post Ghassan Salem: 1 post

People

Translate

site design / logo © 2022 Grokbase