Re: Fast Refresh Materialized View on Prebuilt Table

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Mon, 6 Oct 2014 17:32:08 -0500
Message-ID: <CAEueRAVM-HUWCf9R8dGDg6TS3GxCSTu++or+v40btU8sF+rpKg_at_mail.gmail.com>



It sounds like replication is a good idea but keep in mind that Streams is deprecated.

Seth Miller

On Monday, October 6, 2014, Iggy Fernandez <iggy_fernandez_at_hotmail.com> wrote:

> Perhaps you can use Streams instead of Materialized Views. Streams will
> allow you to apply changes beginning with a specified SCN. Perhaps you can
> "downgrade" to a materialized view once the source and destination tables
> are in sync.
>
> Iggy
>
>
> ------------------------------
> Date: Mon, 6 Oct 2014 14:00:58 +0000
> From: dmarc-noreply_at_freelists.org
> <javascript:_e(%7B%7D,'cvml','dmarc-noreply_at_freelists.org');>
> To: kibeha_at_gmail.com <javascript:_e(%7B%7D,'cvml','kibeha_at_gmail.com');>;
> oracle-l_at_freelists.org
> <javascript:_e(%7B%7D,'cvml','oracle-l_at_freelists.org');>
> Subject: Re: Fast Refresh Materialized View on Prebuilt Table
>
> Hi Kim,
>
> Unfortunately the table is too big and the network too slow/flaky for a
> complete refresh. It's ok for the relatively small daily updates through
> a fast refresh, but a complete refresh requires shipping the table data on
> physical media.
>
> Charlotte
>
>
> On Monday, October 6, 2014 11:57 AM, Kim Berg Hansen <kibeha_at_gmail.com
> <javascript:_e(%7B%7D,'cvml','kibeha_at_gmail.com');>> wrote:
>
>
> Hi Charlotte
>
> Is there a specific reason you wish to copy the table from source to
> target manually and then create the mview using prebuilt?
>
> We use mview replication quite a bit, and I've always just created the
> fast refreshable mviews with "build immediate" and that way let the mview
> do the initial copying of the table.
> That way the source mview log keeps the changes during the mview build and
> then the first fast refresh afterwards will get those changes.
>
>
>
> Regards
>
>
> Kim Berg Hansen
>
> http://dspsd.blogspot.com
> kibeha_at_gmail.com
> _at_kibeha
>
>
> On Mon, Oct 6, 2014 at 12:25 PM, Charlotte Hammond <
> dmarc-noreply_at_freelists.org> wrote:
>
> Hi All,
>
> I'm creating a large fast-refreshable materialized view using a prebuilt
> table.
>
> The problem I have is that by the time I have copied the table from the
> source system to the target system several hours have passed and there are
> now numerous changes on the target. As soon as I issue the CREATE
> MATERIALIZED VIEW command the log is deleted and the fast refresh starts on
> a table which is by now out of date.
>
> I'm looking for a good way to sync up the changes made during the copy
> period. I've got some ideas using triggers (and possibly a small outage
> on the source) but it's seems messy. I'm wondering if I'm missing some
> clean / built-in functionality to resolve this?
>
> The database is 11.2.0.4 SE
>
> Thanks in advance for any ideas!
> Charlotte
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 07 2014 - 00:32:08 CEST

Original text of this message