RE: Materialized View over 2 tables

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Tue, 30 Oct 2001 07:26:08 -0800
Message-ID: <F001.003B8413.20011030074022@fatcity.com>

Helmut,

Rajesh is absolutely correct. If one or more of the base tables are in a remote db then the fast refresh restrictions in the Replication manual apply; if all the base tables are local then the fast refresh restrictions in the Data Warehousing manual apply.

A workaround would be to create simple snapshots off of the base tables so they can be fast refreshed and then either create a view or another snapshot off of the base tables.

HTH,

• Anita
  • Rajesh Dayal <Rajesh_at_ohitelecom.com> wrote:
    > That's not a problem. That is well-documented
    > feature and you can check
    > it with standard documents.
    >  
    > Fast Refreshes are meant only for simple
    > MVs/Snapshots and not for
    > complex ones. You are supposed
    > to do a complete refresh for complex ones.
    >  
    > HTH,
    > Rajesh
    > -----Original Message-----
    > Helmut
    > Sent: Tuesday, October 30, 2001 11:40 AM
    > To: Multiple recipients of list ORACLE-L
    >  
    > Hi!
    > Can I have a materialized view to be refreshed
    > "fast", when it is
    > created over 2 base tables? Fast refreshes work fine
    > as long as the
    > materialized view is based on 1 base table. But if
    > the view is based on
    > more base tables, it only seems to work with a
    > complete refresh.
    > Does anybody have any experience with that problem?
    > This is 8.1.7 on Sun Solaris.
    > Thanks,
    > Helmut
    >
    

    ---

Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.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 Oct 30 2001 - 09:26:08 CST