Re: Substitute for Materialized Views/Snapshots?

Chris,
 If you can do an export of the data you need in a short period of time you could use the CONSISTANT=Y clause to get a "shapshot" of your tables. ROR mª¿ªm

>>> crezek_at_dotclick.com 08/14/01 03:21PM >>> Anita - I checked 112591.1 and also filed an iTAR to confirm with Oracle - there is no materialized view functionality for SE.

Chris - Alas, transportable tablespaces are not available for SE either.

I'm still looking for suggestions. The tables need to be read-consistent down to the second. Is there a way I can do a CREATE AS SELECT or COPY for all five tables in a way that ensures this?

Chris

"A. Bardeen" wrote:
>
> 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: 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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