RE: ** replication remove

  • From: "Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>
  • To: <ajoshi977@xxxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Oct 2006 09:09:55 +0200

May be I have missed something but if replication of materialized view
is now built in CATPROC and is no more an add on script, so you don't
uninstall this capability.
To stop the replication just remove the snapshot logs, propagator, jobs
related to the propagation and target Mview.
For streams, I paid the hard price to know that removing streams from an
installed DB is done using  oracle distributed 'remove_streams92.plb'
package and is not very good. I can testify that you data dictionary is
corrupted somewhere after it is applied on your DB. If you remove and
reinstall the streams, you will have weird things happening in your
exceptions queues and error messages. Some rules remains pending witch
do not belong to any rule sets and conflict with existing rules.
 It is ok on a test DB, until the pain is too high and you will end with
recreating the DB from scratch. I tried re-run CATPROC and catalog, but
this  does not remove the corruption.


From: A Joshi [mailto:ajoshi977@xxxxxxxxx] 
Sent: Monday, 23 October, 2006 4:52 PM
To: Yavor_Ivanov@xxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: ** replication remove

    Thanks. Master2Master. Advanced replication. Thanks a lot for
pointing me to the note 241943.1. 
So if it is de-supported then what would be the way to get rid of
replicaiton. Once the database is replicated it would be difficult to do
database quiesce (suspend) also. since there will not be a secondary.

Yavor Ivanov <Yavor_Ivanov@xxxxxxxx> wrote:

        What kind of replication? Master2Master, Mview, Streams?
        What version of oracle?
        I did not play with catrepr, but according to metalink note
241943.1 CATREPR.SQL id no longer supported as of
        On Sun, 22 Oct 2006 17:41:03 +0300, A Joshi wrote:
        > Hi,
        > I am planning to copy a database that is replicated to another
server. It will not be replicated on this new server. So in order to
remove replication I plan to remove all replication software using
        > I think last time I did this I also had to execute
        > for some tables. So my question is is catrepr.sql enough to
remove replication or is there a better way to remove the replication.
Or some order to be followed. Thanks for the help.
        > ---------------------------------
        > Get your own web address for just $1.99/1st yr. We'll help.
Yahoo! Small Business.


How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call

Other related posts: