Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Replication by materialized view

Re: Replication by materialized view

From: Frank <fvanbortel_at_netscape.net>
Date: Fri, 10 Oct 2003 12:47:34 +0200
Message-ID: <bm62aq$1ot$1@news1.tilbu1.nb.home.nl>


ITAPORT06 wrote:

> I have to replicated (read-only) a single table from 6 different
> databases to one central target database. I understand that making use
> of the materialized view is the easiest method. I assume that there
> is no difference between making use of the snaphot or materialized
> view commands. Is this true?
>

Yes. snapshots == materialized view (as you could have read in the manual)
> The source databases are running on WINNT 8i rel 8.1.7.4
> For the target I can choose: Implement 8i or going to 9i
> For me is the benefit to get some experience with 9i but are there
> also complications for the materialized replication because of using
> the 9i against the 8i
>

Yes - is there a question hidden here? If so, I missed it

-- 
Regards, Frank van Bortel
Received on Fri Oct 10 2003 - 05:47:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US