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 -> What DBMS jobs and database links required for Materialized view replication?

What DBMS jobs and database links required for Materialized view replication?

From: Edwinah63 <edwinah_at_customercare.com.au>
Date: 30 May 2007 22:22:46 -0700
Message-ID: <1180588966.202388.39520@o11g2000prd.googlegroups.com>


Hi Gurus,

I have 2 sites, a master site on A and an MV site on B using primary keys on the replicated tables. The set up, briefly, and in no particular order, is:

On A (master):
* repadmin user

On B (Materialized view)
* mvadmin

The set up was a mix of using the Oracle master/mv site set up wizards and manually executed statements - hence in part my confusion.

Both sites are in a test environment so I have room to experiment.

My problem is that I am unsure about the relationships between the links and the jobs in an MV environment. Also, while I have no problem pulling the data down with the refresh job, the mlog$ tables are not cleared.

Even tho' I have set up a writable MV environment, this is really being used as one way replication.

I have hunted around the web but most articles refer to master to master replication which all specify a push job on each master site and database links.

My questions:

Received on Thu May 31 2007 - 00:22:46 CDT

Original text of this message

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