Re: snapshot vs MV

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 7 Mar 2004 07:55:24 -0500
Message-ID: <TMmdnTWmQdVchtbdRVn-hQ@comcast.com>

"Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message news:PnB2c.91307$Wa.10962_at_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
|
|

actually, as of 8i

SQL reference manual:

ALTER SNAPSHOT
In Oracle8i, "snapshots" are synonymous with "materialized views." Please see
"ALTER MATERIALIZED VIEW / SNAPSHOT" on page 7-47.

;-{ mcs Received on Sun Mar 07 2004 - 06:55:24 CST