Re: To modify the query of a Materialized View

Answers inline

On 9/12/06, Anurag Verma <anuragdba_at_gmail.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l