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: Yavor Ivanov <Yavor_Ivanov_at_stemo.bg>
Date: Mon, 23 Oct 2006 17:26:09 +0300
Message-ID: <op.thvo1vcutjan04@y-ivanov.sf.stemo.bg>

	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 <ajoshi977_at_yahoo.com> 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
Received on Mon Oct 23 2006 - 09:26:09 CDT

Original text of this message

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