drop the multimaster replication set up

Nirmalkumar — Tue, 06 May 2008 06:29:36 GMT

Hi,

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.

Thanks,
Nirmal.

Re: drop the multimaster replication set up

Yogeeraj_1 — Tue, 06 May 2008 08:30:40 GMT

hi Nirmal,

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

hope this helps!
kind regards
yogeeraj

topic Re: drop the multimaster replication set up in Operating System - HP-UX

drop the multimaster replication set up

Re: drop the multimaster replication set up