Re: Materialized view replication problem

From: Bing Wu <bing_at_biop.ox.ac.uk>
Date: Thu, 14 Apr 2005 14:53:35 +0100
Message-ID: <d3lsl0$62n$1@news.ox.ac.uk>

Noons wrote:
> You might want to call the admin user REPADMIN in the master
> node and MVADMIN in the MVIEW site. It helps to keep them
> separate unless you want to also replicate somewhere
> else from the MVIEW node.

I uses REPADMIN across all sites, for easy management.

> The whole thing could have been better documented
> and managed by Oracle, IMHO... Since it's been internalized,
> it's like pushing water upstream without a paddle to get
> the darn thing working. And no: OEM does NOT help at all.
> If anything it makes things even more confusing!

Yes, I agree. It is much easier to write some PL/SQL to deploy replication than OEM (which I tied initially and gave up).

ta,

Bing Received on Thu Apr 14 2005 - 08:53:35 CDT