Re: Substitute for Materialized Views/Snapshots?

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Tue, 14 Aug 2001 06:51:07 -0700
Message-ID: <F001.003698D0.20010814054046@fatcity.com>

Chris,

Read-only and updatable snapshots/materialized views are available with the Standard Edition starting with 8.1.5; SE can also be used for the master site for snapshots/MV's. EE is required only for multi-master replication and the data warehousing features of MV's (e.g. summary management, etc...)

The following metalink doc has the differences:

Note: 112591.1 "Differences Between Standard Edition and Enterprise Edition in 8i"

HTH,

• Anita
  • Chris Rezek <crezek_at_dotclick.com> wrote:
    > We are running 8.1.6 Standard Edition on Solaris
    > hardware. We are
    > building a reporting system and would have liked to
    > use materialized
    > views (snapshots) but this feature is not available
    > in Standard
    > Edition. We need to create read-consistent copies
    > of several
    > million-row tables each night at midnight. How can
    > we do this without
    > Oracle's auto-updating materialized views?
    >
    > Chris Rezek
    > Oracle DBA
    > http://www.dmn.com
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: Chris Rezek
    > INET: crezek_at_dotclick.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >
    

    ---

    
    > 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).
    

    ---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Tue Aug 14 2001 - 08:51:07 CDT