Re: ** replication remove

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://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>

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