Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> What DBMS jobs and database links required for Materialized view replication?
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:
![]() |
![]() |