Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** replication remove

Re: ** replication remove

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Mon, 23 Oct 2006 07:52:06 -0700 (PDT)
Message-ID: <20061023145206.8602.qmail@web62408.mail.re1.yahoo.com>


Yavor,

      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. Thanks.

Yavor Ivanov <Yavor_Ivanov_at_stemo.bg> 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 9.2.0.2

Regards,
Yavor

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 catrepr.sql.
> I think last time I did this I also had to execute sys.dbms_internal_trigger.destroy
> 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.

--
http://www.freelists.org/webpage/oracle-l




 		
---------------------------------
How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 23 2006 - 09:52:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US