Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

drop the multimaster replication set up

Frequent Advisor

drop the multimaster replication set up


i have dropped the multimaster replication setup by the following steps

1.Login as repadmin user

2.execute dbms_repcat.suspend_master_activity(gname=>'REPLIC');

3.execute dbms_repcat.drop_master_repobject('DL','TEST12','TABLE');

4.execute dbms_repcat.remove_master_databases('REPLIC','DL.PNGEDMS2.AMD.COM');

5.execute dbms_repcat.drop_master_repgroup('REPLIC');

Replication Group name : REPLIC
Object and schema used for replication: TEST12 and DL
Master site : DL.PNGEDMS2.AMD.COM

The above things are i have did in master defintion site.all the things are dropped fine in master definition site.i have checked the dba_repsites and dba_repobject views ,did not find any records.

In the master site,i found the records in dba_repsies and dba_repobject views.the found records are the records which i have dropped in master definition site.

please help me out how to remove the records in master site or anything need to alter in the dropping steps which i have did in master def. site.

Honored Contributor

Re: drop the multimaster replication set up

hi Nirmal,

If you have access to metalink, please refer to "7. Drop Replication setup" in note 250048.1

hope this helps!
kind regards
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)