Upgrade -basic Advanced Replication/Materialized View

  • From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 4 Sep 2006 18:39:59 +1000

Hi Guys,


We've got basic Advanced Replication (yes, basic Advanced!!) implemented
on one of our databases. The set up is a single group, with 200+
tables in it. (Hey, I took over this system after the guy who initially
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 which
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 upgrade
notes for I've upgraded databases without Adv. Rep. before but
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 slave?
Can it remain on its Oracle version? No, I don't know what version they
are running over there.









Leng Kaing

Senior Oracle DBA

Hansen Technologies; 2 Frederick St; Doncaster 3108

Ph: +61-3-9840-3832



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 

Other related posts: