Re: snapshot vs MV

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Sun, 07 Mar 2004 08:50:55 GMT
Message-ID: <PnB2c.91307$Wa.10962@news-server.bigpond.net.au>

"zeb" <spam_at_nowhere.com> wrote in message news:404adb75$0$289$626a14ce_at_news.free.fr...
> Hi,
>
> Is there any differences between snapshot and materialized views
> or is it exactly the same thing with a new name ??
>
> Thanks for your lights...
>
>

Zeb,

With Oracle 9i and later, the answer is that they are the same. Indee, the 9i SQL Reference says that "The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW for backward compatibility." (p 14-5).

Douglas Hawthorne Received on Sun Mar 07 2004 - 02:50:55 CST