Oracle-L: RE: materialized views

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 23 Oct 2002 14:14:19 -0800
Message-ID: <F001.004F1CDF.20021023141419@fatcity.com>

Gary - I seem to recall a restriction based on the refresh scheme. Something like if the underlying materialized view/snapshot has a refresh log, then the new materialized view can't be fast refreshed, or something like that. Other than that, maybe the best approach is to just try it.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, October 23, 2002 4:45 PM To: Multiple recipients of list ORACLE-L

Can anyone confirm whether or not a materialized view in 8.1.7 EE can be based upon a snapshot within the same schema?

SunOS 5.6 - 8.1.7.0.0 EE

Get a speedy connection with MSN Broadband. Join now! http://resourcecenter.msn.com/access/plans/freeactivation.asp

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gary Jackson
INET: fred_fred_1_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------