Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Upgrade -basic Advanced Replication/Materialized View

RE: Upgrade -basic Advanced Replication/Materialized View

From: Leng Kaing <>
Date: Wed, 6 Sep 2006 10:10:36 +1000
Message-ID: <>

Thanks very much for your reply, Yavor! This was exactly the information I was looking for.

Yes, I'll be testing before doing the real prod upgrade but having prior warnings is always much appreciated!!


Leng Kaing
Senior Oracle DBA
Hansen Technologies; 2 Frederick St; Doncaster 3108 Ph: +61-3-9840-3832
-----Original Message-----
From: Yavor Ivanov [] Sent: Wednesday, 6 September 2006 1:16 AM To: Leng Kaing;
Subject: Re: Upgrade -basic Advanced Replication/Materialized View

        Hi, Leng

        I have setup with 12 servers running (1 master and 11 snapshot sites) with > 1000 snapshots on ~10 groups replicating to any of the sites. We have some very andavnced things like 3-tier replication, triggers, etc. I've managed this system for years, and I can tell you there is nothing special for any patch/upgrade/migration (I'we walked the path form 8i->9iR1->9iR2->10gR1). In fact, there was only one very nasty bug in 8i->9i migration, but this is not your case.

        So, in brief: just do anything as in the docs and you will not have any problems. But there are some things you could do, just to be sure:

Yavor Ivanov
Senior Database Expert
Stemo Ltd

On Mon, 04 Sep 2006 11:39:59 +0300, Leng Kaing <> wrote:

> Hi Guys,
> We've got basic Advanced Replication (yes, basic Advanced!!)
> on one of our databases. The set up is a single group, with
> tables in it. (Hey, I took over this system after the guy who
> set it up left so I had no say in this matter!) We have materialized
> view logs capturing the changes. The slave is on a client site for
> I am not responsible but I think they'll still need our help of the
> upgrade causes any issues at their end.
> So can you please share any experiences with upgrading Adv. Rep. from
> to Is it just as simple as ensuring that the MLOG$
> tables are empty (after a refresh) and the following the normal
> notes for I've upgraded databases without Adv. Rep. before
> have not done it on databases running Adv. Rep. let alone materialised
> views. Any gotchas or bugs I need to be aware of? What about the
> Can it remain on its Oracle version? No, I don't know what version
> are running over there.
> TIA,
> Leng.


This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Hansen Technologies Limited or third parties. Copying, distributing, disclosing, commercialising or otherwise acting in reliance on this e-mail and any attachments is strictly prohibited unless you are the addressee of this e-mail and have written permission to do so. If you have received this e-mail in error please delete this e-mail (including any copies and attachments) and contact Hansen Technologies Limited by return e-mail or by telephone on + 61 3 9840 3000. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of or be a commitment by the organisation, except where the individual sender has the authority and expressly states them to be so.

Received on Tue Sep 05 2006 - 19:10:36 CDT

Original text of this message