Re: ** replication remove

Yechiel,

     Thanks. I assume quiesce/suspend is not needed. I think the trick is going to be of help. Thanks   

Yechiel Adar <adar666_at_inter.net.il> wrote:   Very simple.

Connect, in sqlplus, as replication manager and then do:

begin
dbms_repcat.drop_master_repgroup(
gname => 'group name',
drop_conetnts => false,
all_sites => false);
end;
/

The trick is in: all_sites => false that tell it not to go and search for the other server.
We did it to test working with the second server when the first one is down.

Adar Yechiel
Rechovot, Israel

A Joshi wrote:

> 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.
>
> *//*
>

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




 		
---------------------------------
Stay in the know. Pulse on the new Yahoo.com.  Check it out. 
--
http://www.freelists.org/webpage/oracle-l